What type of JOIN to use
What type of JOIN would I use to get table1
and table2
to be matched only once. For example, I have table1
(40 rows) and table2
(10000 rows). But I get table1
repeated over and over when I use a join on table1.LocationArea = table2.Location