Join Two Tables in ASP

Ive got two tables that store customer details which have no relationship. so for example a customer may exist in the one database but not the other or he could exist in both. How could i join these databases and throw out only records that have duplicate email address

Thanks in advance
KeKiteleyAsked:
Who is Participating?
 
jitgangulyConnect With a Mentor Commented:
Select a.*,b.*
from mytab a, mytab1 b
where a.email in (select email from maytab1)
0
 
babuno5Connect With a Mentor Commented:
select * from table1,table2 where table1.email = 'Your Email  ';
0
 
fozyletConnect With a Mentor Commented:
Select * from Table1
INNER JOIN Table2 ON Table1.email=Table2.email
0
 
KeKiteleyAuthor Commented:
Thanks

sorry for the very delay
0
All Courses

From novice to tech pro — start learning today.