If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there a join that does this?
I need an INNER JOIN of TableA and TableB, and then I also want the rows of
TableA that DON'T have a match in TableB, and then vice versa. So basically every row from both tables would be represented, and any rows that matched up would be joined. Kinda like a LEFT JOIN plus a RIGHT JOIN. Is there a way to get this? |
#2
|
|||
|
|||
Is there a join that does this?
yeah use a union query
select tablea.*,tableb.* from tablea left join tableb on tablea.id = tableb.id union select tablea.*,tableb.* from tablea right join tableb on tablea.id = tableb.id that query should and i say should cause it is untested preduce no duplicates because it is union and not union all. hope this helps Regards Kelvan |
#3
|
|||
|
|||
Is there a join that does this?
i realised after making my above post that that is a technical
impossibility because it woudl state you have a many to many join with no table inbetween can you tell me your table structure. Regards Kelvan |
Thread Tools | |
Display Modes | |
|
|