Syed Ali Shah Rashdi
asked on
sql jOINS ??
I have a query in that i have 3 col where i have customer id ; i need customer names against those id, i am using left outer join for first one it works but if i use 2 more joins to get names for 2 other col it goes to sleep takes hell of time is there faster or better way ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Post your query as well sample data so we can assist you better.
Why not include your current query (this one: "I have a query in that i have 3 col ") then at least we can understand what you are doing now.
---------------
The very best technique for asking SQL questions is to do this:
a. supply "sample data"; this should be for EACH table separately. NOT a lot of data is needed.
b. he "expected result" based on the sample data, what result do you want
Excel is a good tool for figuring this out and you can attach the spreadsheet to the question.