Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL question
Message
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL question
Divers
Thread ID:
00364149
Message ID:
00364149
Vues:
54
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

Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform