>SELECT Dailywork.ddate, Dailywork.cgang, Dailywork.cblock,; > Dailywork.nmen+Dailywork.nwmn+Dailywork.nadl AS heads,; > Dailywork.ncode, Pkg.nripe, Pkg.ngreen; > FROM ; > GUINTY!DAILYWORK ; > INNER JOIN GUINTY!PKG ; > ON Dailywork.ncode = Pkg.ncode; > WHERE Dailywork.copr = ( "PKG" ); > ORDER BY Dailywork.ddate >>