General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only