How do I use a Data Adapter configuration wizard to generate a query that will compare the variable in the query to my run time variable?

This is what I have but it doesn't work. The wizard kept giving me errors:

SELECT
Personal.*,
Education.*,
Response.*
FROM
Education,
Personal,
Response
WHERE
Personal.SSN = @intSSN
Response.SSN = @intSSN
Please help if anyone knows.

Thanks!

Chong