SQLTeam.com | Weblogs | Forums

Combine 2 select statements


#1

SELECT

 part.num, woitem.qtytarget AS woitemqty,
 
(SELECT LIST(wo.num, ',') 

FROM wo INNER JOIN moitem ON wo.moitemid = moitem.id

WHERE moitem.moid = mo.id) AS wonums, mo."USERID" AS mo_USERID

FROM mo
INNER JOIN moitem ON mo.id = moitem.moid

LEFT JOIN wo ON moitem.id = wo.moitemid
       
LEFT JOIN woitem ON wo.id = woitem.woid AND woitem.typeid = 10
LEFT JOIN (Select sum(woitem.qtytarget) as labor, woitem.woid, uom.code as uom
                from woitem
          JOIN part on woitem.partid = part.id and part.typeid = 21
                JOIN uom on woitem.uomid = uom.id
              group by 2,3) as labor on wo.id = labor.woid
LEFT JOIN part ON woitem.partid = part.id

where woitem.qtytarget/wo.qtytarget IS NOT NULL

SELECT
MO."USERID" AS MO_USERID,
SYSUSER."USERNAME" AS SYSUSER_USERNAME
FROM
"SYSUSER" SYSUSER INNER JOIN "MO" MO ON SYSUSER."ID" = MO."USERID"


#2

not clear what you are trying to achieve. Please post some sample output


#3

Same / similar query appeared in another thread, in case it clarifies in some way?