SQL语句:
select coalesce(aa.devid,bb.llb_id) as devid , aa.llb_used,bb.used from tab1 aa
full join tab2 bb on aa.devid=bb.llb_id
SQL语句:
select coalesce(aa.devid,bb.llb_id) as devid , aa.llb_used,bb.used from tab1 aa
full join tab2 bb on aa.devid=bb.llb_id