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~