If I have below two tables, how to combine those two ?
Table_A:
Load
Name,
City,
Occupation,
Income
From qvda;
Table_B:
Load
Name,
City,
SSN,
Blue__Red_Ind
From qvdb;
I want output whenver Name and City combination matches from Table A to Table B. (If data for A is present in B populate Blue_red_Ind else put blanks in field Blue_Red_Ind.)
Expected table columns
Name,City,Occupation,Income,City,Blue_Red_Ind
I was thinking Simple Join should work , but not sure if it is Friday Night so its not working.
Should I try to concatenate both fields(Name and City ) to create a new field? Is it possible?
As I mentioned earlier inner join also seems to be working somehow. But good to know these other options incase inner join gives other problems. This was really healpful.
Sorry I meant to say "Left Join" seems to be working as of now. But good to know these other options incase left join gives other problems. This was really helpful.
