Using Two Tables

[outpost]

Hello Experts and All ...

I'm attempting to use fields in 2 tables from the same database.

The correct combination hasn't popped up in research as I've been trying variations of:

"SELECT * FROM table1,table2 WHERE (table1.field1 AND table2.field1 = '$var1') AND (table1.field2 AND table2.field2 = '$var2')"; 

Variables (var1 and var2) are passed from a previous HTML page link and the query works well with either table individually but, of course, not with them together.

Any suggestions with this will guarantee your place at the front of the next line. Thanks.

[lius]

Try:

SELECT * FROM table1,table2 WHERE (table1.field1= '$var1' AND table2.field1 = '$var1') AND (table1.field2= '$var2' AND table2.field2 = '$var2')";

[outpost]

Thank you Luis. It's so obvious ... now! Go to the front any line!