Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need help with simple SELECT - SQL command
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Need help with simple SELECT - SQL command
Divers
Thread ID:
00617474
Message ID:
00617474
Vues:
61
All I want to do is select records from two tables by looking at one field in each table. I want to find what states in table 2 are not in table 1. What would the SELECT- SQL command look like to do this? THANKS!

For example lets say Table 1 is my working table with state records in it.
NY
NJ
FL
CA
TX

Table 2 is a table with all the states in it.
AL
AK
AR
... and so on
WV
WY
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform