select distinct your_value from (
select your_value from table_1
union
select your_value from table_2
union
select your_value from table_3
union
select your_value from table_4
) x;select t1.name, t2.name
from table_1 t1, table_2 t2
where t1.id = t2.id;
select
t2.Id,
t2.Name,
t3.Date,
t2.Other
from
(
select
t1.Id,
t1.Name,
t1.Date,
t1.Other
from your_table t1
where not exists (
select 1
from your_table
where Id = t1.Id
and Date > t1.Date
)
) t2 join (
select
Id,
Name,
Date as Date,
Other
from test4
where Other = 555
) t3 on t3.Id = t2.Id
select
...
from job
join status on status.jobID = job.jobID
join worker on worker.workerID = status.workerID
join client on client.clientID = client.clientID
join responsible on responsible.responsibleID = job.responsibleID