Syntax error when trying to JOIN from 2 tables

[spentastic32]

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