What's the proper way of saying this?<BR><BR>(I want all rows from both tables, and a Left Join between Invoices and Partners...) Thanks!<BR><BR>SELECT Partners.*, Invoices.* LEFT JOIN Partners ON
http://www.w3schools.com/sql/sql_join.asp<BR><BR>That helped me a LOT. check it out.
Select * From Partners Inner Join Invoices ON Partners.[Field] = Invoices.[Field]<BR><BR>