>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
SELECT ARCust.*, Address1.Address, Address2.Address FROM ARCust, Address Address1, Address Address2 WHERE ARCust.AddressID1 = Address1.ID and ARCust.AddressID2 = Address2.ID
Erik Moore
Clientelligence