Mysql - Query Problem

[mikelee]

AS I know, MYSQL don't support full outer join
so i have some problem for my query,
I have 2 table
table 1
{ id
date
other infomation....
}

table 2
{ id
date
remark
}
now i need to show a table something like other join,
show the record once it exist on each table or both,
how can i do this?

THANKS~

[deathrider]

It depends on how you relate the 2 tables...with the date?
Or are the id field values the same?

Well...i presume the id fields are the same now:

SELECT table1., table2. FROM table1, table2 WHERE table1.id = table2.id ORDER BY yourorder

or

SELECT table1., table2. FROM table1, table2 LEFT OUTER JOIN table2 AS table2_1 ON table1.id = table2.id WHERE yourtable.yourcriteria = yourvalue GROUP BY yourtable.yourgroupingfield ORDER BY yourtable.yourorder

i hope that helps

[Lars_Berg]

A full outer join is a shorthand for a union query

select * from t1 join t2 on t1.id = t2.id
union all
select * from t1 left join t2 on t1.id = t2.id where t2.id is null
union all
select * from t1 right join t2 on t1.id = t2.id where t1.id is null