Re: Help in joining three tables

[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 on ProdNo,CustNo and Branch. Table3 will be
>joined to the result set by CustNo and Branch.
>
>Best regards
>Imran. 
>
>  
>
Go ahead. That should work if you leave out the parenthesis.

>
>  
>