sql - MySQL full inner join -

i have

select clientreport.id  clientreport  left join report02 on (report02.id = clientreport.id) report02.id null; 

that equivalent of

select clientreport.id clientreport.rownumber not exists ( select clientreport.rownumber report02, clientreport report02.id=clientreport.id); 

i need, presumably, full inner join mismatches in report02, not clientreport. how write join this?

the below should work.

select clientreport.id,report02.id clientreport  full outer join report02 on (report02.id = clientreport.id) report02.id null or clientreport.id null; 

it should doesn't (as mysql not support full outer join.)

this more work:

( select clientreport.id  report01        , report02.id      report02   clientreport    left  outer join report02       on (report02.id = clientreport.id)   report02.id null ) union ( select clientreport.id  report01        , report02.id      report02   clientreport    right outer join report02       on (report02.id = clientreport.id)   clientreport.id null )