Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inner join where items do not match
Message
From
29/10/2002 11:19:09
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Inner join where items do not match
Miscellaneous
Thread ID:
00716464
Message ID:
00716464
Views:
46
Hi,


TABLE A
--------
NAMEID
NAME

TABLE B
--------
ORDERID
NAMEID


I would like to find out rows that exist in table A that do not exist in table B.... and vice versa...

Thanks.
Alvin
Next
Reply
Map
View

Click here to load this message in the networking platform