forum

Home / DeveloperSection / Forums / What type of join should I use?

What type of join should I use?

Anonymous User221211-Mar-2013

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!


Updated on 11-Mar-2013
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By