By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,071 Members | 1,059 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,071 IT Pros & Developers. It's quick & easy.

Left Join with More than 2 tables

P: 1
I'm not sure if this is the right forum, so please forgive me if I"m off.

I'm doing a query from MS Excel using the Query Wizard.
I'm pulling from 4 different JDE Tables.

I need to join AND left join two tables, but it tells me Left joins aren't allowed with more than two tables.

Any thoughts

Table 1- Sales information
Table 2- Addresses
Table 3- Cstmr Names
Table 4- Phone Numbers

I'm pulling information from table 1 that includes Cstmr numbers. Sometimes there are two customers per sale.

I need the address (tbl 2), name (tbl 3), and phone number (tbl 3) of the first customer.
I need the name (tbl 3) of the second cstmr, and would also like the phone number.

When I do straight joins, it only pulls down data where there are two customers.

Its a long statement, so I haven't included it here, but I can if needed.
Feb 27 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 4,258
Since this is the MySQL forum I am afraid I cannot help you. You'll have to try an Excel forum.

Ronald :cool:
Feb 28 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.