How to add a Table to an existing SQL statement 1

[rwn]

I have this existing functional SQL and need to add the Customer Table to this SQL:
The current SO_Header table has a field called "SO_Header.Customer" and the Customer table has a field called "Customer.Customer" these to need to be linked in the below SQL.


sql = sql & "FROM SO_Header INNER JOIN (SO_Detail LEFT JOIN Material ON SO_Detail.Material = Material.Material) " _
& "ON SO_Header.Sales_Order = SO_Detail.Sales_Order " _
& "WHERE SO_Header.Status IN('Hold', 'Open') "

 

[1DMF]

What type of link?

LEFT, RIGHT, INNER?

sql = sql & "FROM SO_Header INNER JOIN (SO_Detail LEFT JOIN Material ON SO_Detail.Material = Material.Material) " _
& "ON SO_Header.Sales_Order = SO_Detail.Sales_Order " _
& "INNER JOIN Customer ON SO_Header.Customer = Customer.Customer " _
& "WHERE SO_Header.Status IN('Hold', 'Open') "

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[rwn]

INNER JOIN is PERFECT! Thank you