Compare design time variable to run time variable

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:

Quote:

---

SELECT
Personal.*,
Education.*,
Response.*
FROM
Education,
Personal,
Response
WHERE
Personal.SSN = @intSSN
Response.SSN = @intSSN

---

Please help if anyone knows.

Thanks!

Chong

I usually put the query in a stored procedure, and then pass in my runtime values as parameters.

Not all datasources support parameters, or some support them differently. What datasource are you using? Access? SQL?

It looks like your query is wrong too. Should it be a join statement?

Thanks for helping me out. I am using MS Access mdb. The codes was just a sample I copied from the configuration wizard. It doesn't matter if I have the join or not. I was trying to do it in different ways but obviously it doesn't work.

How do I use store procedure?

Thanks!

Chong