Hi, i am trying to run a query to select information from two tables. i am getting syntax error near ‘join’
The main grid has the bulk of the info (LOADS). There is a second table below this (LOAD_PAY_INFO_DETAIL) which has rate and payment information. both tables have the column LOAD ID. I have tried a few different ways to get this to work, but i am stuck. you can see the jist of the query below (please help):
select * from loads
where ProductID='LOG' and Date_In> '2021-05-31'
JOIN Quantity, Rate, Uom ON LOAD_PAY_INFO_DETAIL