I'm sure you're not using SQL Server, but I guess this should work as expected.

SELECT labtrans.transdate,

labtrans.laborcode,

labtrans.regularhrs,

labtrans.startdate,

labtrans.craft,

labtrans.refwo,

task.worktype,

task.parent,

parent.wonum,

parent.location,

parent.worktype,

matusetrans.itemnum,

matusetrans.mrnum,

matusetrans.transdate,

matusetrans.actualdate,

matusetrans.issuetype,

matusetrans.description,

matusetrans.storeloc,

matusetrans.refwo,

matusetrans.linetype,

labor.personid,

matusetrans.issueto,

asset.eq1

FROM labtrans

JOIN workorder task ON labtrans.refwo = task.wonum

JOIN workorder parent ON task.parent = parent.wonum

JOIN labor ON labtrans.laborcode = labor.laborcode

LEFT JOIN matusetrans ON labtrans.refwo = matusetrans.refwo

AND convert (char( 20 ),labtrans.startdate,6) = convert (char( 20 ),matusetrans.transdate,6)

AND (matusetrans.linetype = 'WAREHOUSE ITEM' or matusetrans.linetype = 'TOOL ROOM')

AND labor.personid = matusetrans.issueto

LEFT JOIN asset ON task.assetnum = asset.assetnum

WHERE (parent.worktype <> 'A') and

(labtrans.craft >= '611-ELEC' and

labtrans.craft <= '619-SMWE') and

( labtrans.startdate >= :from_date and labtrans.startdate <= :thru_date )