select 1 id, '无计划' demandName,'无计划' dsc,'无计划' planNameunion allselect A.id,A.demandName,A.dsc,C.planName from demand A,TPRG_PlanAndDemand B,TPRG_Plan Cwhere A.id = B.DemandId and B.PlanId = C.id