You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
-
O
using innerjoin or left join is the good ways, you could left join and in where clause let the fieldname is null
