Please help me, is there any sql syntax where it looks like a vlookup formula in excel. i have 2 tables, Table_A as the source of data and Table_B is the looking up of values. Tables_A&B will be display as a result.
Will i get a result of let say, below example Table_A A1 is my source and im going to look for the value on Table_B B3, the condition is if there is no value to lookup at Table_B B3 then Table_A A1 will still be there and Table_B B3 is blank as a result.
You should ue LEFT JOIN instead of INNER JOIN in the query that I posted earlier; that will give you the row(s) from the source table (Table A) even when there are not matching rows in the right table (Table B).