Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL question
Message
From
27/04/2000 12:13:41
 
 
To
All
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Title:
SQL question
Miscellaneous
Thread ID:
00364149
Message ID:
00364149
Views:
56
How would I do a 'non-join' :) (Would this be a part?) I want all the values from table 1 that don't exist in table2.

I have two tables for simplicity table1 would have one field 'num' and would have numbers 1 - 20. Table2 has one field 'num' and has 1 - 15.
Table1    table2
1         1  
2         2
.         .
.         .
.         . 
18        13
19        14
20        15 

The answer I want in our exaple here is:

Query results
16
17
18
19
20
~Joe Johnston USA

"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams

Next
Reply
Map
View

Click here to load this message in the networking platform