I need to join two tables, one table is called budget which has 4 colummns: clientNo, ClientName, budge, Sales
another table is call profit which has 3 columns: fcustno, fsalespn, profit.
I need to join two tables together base on clientNo and sales, but i need keep all records in budget table.
the queries I use is
select * from budget A
left join profit B on b.fsalespn = A.sales_rep and B.fcustno = A.client_no
but it didn't get all records from budget table.
how do I achieve it? thanks