SQL Join Statement - (parameter)

I have two tables with a common key field "a"

Table1	Table2		


-field1	field1


-field2	field4


-field3	field5

Based on an input parameter, I would like to retrieve the record where (field1 = input Variable) and list out all the fields from both table 1 and table2.

When I deal with a single table (table1), I use the SQL statement ;

Select field1, field 2, field3
from table1
where field1 = inputVariable;

Hope some of you could help me with these SQL Join statement...

Thanx. Received on Wed Jul 08 1998 - 09:24:44 CDT