Use an inner join based on your keys.

Select table1.fieldname, table1.fieldname ,
       table2.fieldname,table2.fieldname
       join table1.key  on table2.key
where table1.key = table2.key

Remeber that the keys have to match, ie.table1.custid = table2.custid
(ie custid is key in both tables)


---
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com