Help With Inner Join

[ctau]

I need help with the syntax to join to tables together using a Select statement. Here is what I have been trying so far

SQL_Statement = "SELECT * FROM return_header Inner JOIN return_line ON return_header.return_number = return_line.return_number"

 

[ctau]

I finally go this working. Here is what I did incase it helps someone.



SQL_Statement = "SELECT * FROM return_header RH, return_line RL where RH.return_number = RL.return_number"