Hi All!
My join knowledge is terrible, I can't find the correct one for this. I want to join the two tables on the TableA.userID and the TableB.otherID to match the
desired output. I don't have any foreign or primary keys set on the tables. What should I be using here?
TableA:
userID
field1
field2
TableB:
userID
otherID
myData1
myData2
myData3
Desired Output:
userID
otherID
myData1
myData2
myData3
field1
field2
Thanks in advance!
AVADHESH PATEL
11-Mar-2013