p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

sql_language thread: help wanted with query


Message #1 by Abhijit <Abhijit@e...> on Thu, 21 Dec 2000 16:07:00 -0000
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

  Return to Index