select ER_CGSQMXB.*,ER_WPXX.fWPBM as fWPBM,ER_WPXX.fWPMC as fWPMC,ER_WPXX.fGG as fGG,ER_WPXX.fDW as fDW
from ER_CGSQMXB ER_CGSQMXB
optional join ER_WPXX ER_WPXX on ER_CGSQMXB.fWPID = ER_WPXX
select ER_CGSQMXB.*,ER_WPXX,ER_WPXX.fWPBM as fWPBM,ER_WPXX.fWPMC as fWPMC,ER_WPXX.fGG as fGG,ER_WPXX.fDW as fDW
from ER_CGSQMXB ER_CGSQMXB
optional join ER_WPXX ER_WPXX on ER_CGSQMXB.fWPID = ER_WPXX