Posted by Nail �nl� on 10/29/05 18:36

Hiho,

I have the following problem. Two tables which have the same primary key
"statusid". I one table i have 10 entries and in the other 7. The 7 from
the second table are also in the first. What i want to do is to get
the other 3.

As the 7 are flagged with a special value, i want to get the other 3,
which dont have this flag.

I know that i can do a UNION to get distinct values from two tables but
i cant do that as the fields are not the same beside the statusid.

To simplfy it:

Table1
-----------------------
statusid | flag |
2123123 | A |
2342342 | B |
3450983 | C |


Table2
-------------------------------
statusid | other fields... |
2123123 | ... |
2342342 | ... |
3450983 | ... |
0980234 | ... |
2342344 | ... |



i hope someone can help me out on this

cu,
Nail

• Next in forum: Get ID's from two different tables
• Prev in forum: Get ID's from two different tables
• Thread view: Get ID's from two different tables

[Reply to this message]