Help in joining three tables

2006-01-18 Thread Imran
Hello All: I need to join three tables but I am not sure how to structure the query. I need to join table1 to table2 and then join table3 to this result set. So like (table1 join table2) join table3. Table1 and Table2 will be joined on ProdNo,CustNo and Branch. Table3 will be joined to the

Re: Help in joining three tables

2006-01-18 Thread SGreen
Imran [EMAIL PROTECTED] wrote on 01/18/2006 03:13:08 PM: Hello All: I need to join three tables but I am not sure how to structure the query. I need to join table1 to table2 and then join table3 to this result set. So like (table1 join table2) join table3. Table1 and Table2 will be

Re: Help in joining three tables

2006-01-18 Thread gerald_clark
Please do not hijack someone elses thread. ]Imran wrote: Hello All: I need to join three tables but I am not sure how to structure the query. I need to join table1 to table2 and then join table3 to this result set. So like (table1 join table2) join table3. Table1 and Table2 will be joined

Re: Help in joining three tables

2006-01-18 Thread Rhino
- Original Message - From: Imran [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, January 18, 2006 3:13 PM Subject: Help in joining three tables Hello All: I need to join three tables but I am not sure how to structure the query. I need to join table1 to table2

Re: Help in joining three tables

2006-01-18 Thread SGreen
Rhino [EMAIL PROTECTED] wrote on 01/18/2006 03:30:44 PM: - Original Message - From: Imran [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, January 18, 2006 3:13 PM Subject: Help in joining three tables Hello All: I need to join three tables but I am not sure

Re: Help in joining three tables

2006-01-18 Thread Rhino
- Original Message - From: [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED] Cc: Imran [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, January 18, 2006 5:07 PM Subject: Re: Help in joining three tables Rhino [EMAIL PROTECTED] wrote on 01/18/2006 03:30:44 PM: - Original