Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Select with multiple joins
The Help File has SQL SELECT Examples my dog couldn't benifit from so could someone tell me how to do something like this:
I've got a ARCust file, with 2 foriegn keys to address, 1 for the address info (includes Name, Phone, ect.) of the customer and 1 for the ShipTo of another customer. So what I do in data environments is add the address table 2 times with two aliases and set the relationships up. So could someone give me an example of a SELECT statement that would work for me.
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement