FULL OUTER JOIN With MySQL, MySQL don't support ist what is the solution for more than 2 Tables? select * from

(select col1,col2,col3 from tableA 
where col1 like 'somthing1'
and col2 like 'somthing2' ) as t1

left join

(select col2,col2, col3 from tableB
where col2 like 'somthing1'
and col2 like 'somthing2') as t2

on t1.col3= t2.col3

left join

(select col2,col2, col3 from tableC
where col2 like 'somthing1'
and col2 like 'somthing2') as t3

on t2.col3= t3.col3

left join

(select col2,col2, col3 from tableC
where col2 like 'somthing1'
and col2 like 'somthing2') as t4

on t3.col3= t4.col3

UNION

(select col1,col2,col3 from tableA 
where col1 like 'somthing1'
and col2 like 'somthing2' ) as t1

right join

(select col2,col2, col3 from tableB
where col2 like 'somthing1'
and col2 like 'somthing2') as t2

on t1.col3= t2.col3

right join

(select col2,col2, col3 from tableC
where col2 like 'somthing1'
and col2 like 'somthing2') as t3

on t2.col3= t3.col3

right join

(select col2,col2, col3 from tableC
where col2 like 'somthing1'
and col2 like 'somthing2') as t4

on t3.col3= t4.col3
Build a VIEW that simulates a FULL OUTER JOIN of A and B.  (Use the template given by some of the links.)
Build a VIEW that simulates a FULL OUTER JOIN of that VIEW and C.  (Use the template given by some of the links.)
Etc.


Eventually, you will have a FULL OUTER JOIN of all the tables without the ugly mess of compounding the number of joins needed.