Okay,
Now I understand what you want. (For people who try to unsub me from this
list: Sorry I only try to help, if you are not intressted in it pleasee
dont read)
If you start using MySQL 4.1 (Only ALPHA) then you can use subqueries like
this:
select *
from table1
where id not in
( select
I need to find out, using a join, which corresponding rows in a union
that is missing. But it is among a certain subselect I want to do
this, that is, among the rows where the column lang = 'uk' for
example.
The two tables looks like following:
+---++---+
| id |
If I'm right you want to do a left join.
For example:
Table1:
Id value
1 100
2 200
3 300
Table2:
Id RefId OtherValue
1 1 9000
2 1 1
3 2 8000
If you do this:
select