i have two queries the first one :

` Select VCRNUM_0 As 'Tranx_Number', ACTQTY_0 As 'Quanity', sto.CREDAT_0 As 'Create_Date', sto.PROD_DATE_0, sto.PROD_TIME_0, sto.CREUSER_0, sto.ITMREF_0, sto.VCRNUMORI_0 as 'Work_Order_number', itm.ITMWEI_0, sto.ACTQTY_0 * itm.ITMWEI_0 As Weight, itm.ITMDES1_0 as 'SKU_Description', a1.TEXTE_0 As 'Work_Center_Description', gope.CPLWST_0 as 'Work_Center_Number' From ZSTOJOU sto JOIN MFGOPE gope on sto.VCRNUMORI_0 = gope.MFGNUM_0 LEFT JOIN ATEXTRA a1 ON gope.CPLWST_0= a1.IDENT1_0 and a1.CODFIC_0 = 'WORKSTATIO' and a1.ZONE_0='WSTDESAXX' AND a1.LANGUE_0='ENG' LEFT JOIN APLSTD APL ON sto.TRSTYP_0= APL.LANNUM_0 and APL.LAN_0= 'ENG' and APL.LANCHP_0 = 704 LEFT JOIN ITMMASTER itm on sto.ITMREF_0=itm.ITMREF_0 Left Join ATEXTRA a2 On itm.TSICOD_6=a2.IDENT2_0 and a1.CODFIC_0 = 'ATABDIV' and a2.ZONE_0='LNGDES'AND a2.LANGUE_0='ENG'And a2.IDENT1_0=26 WHERE sto.TRSTYP_0 =5 and sto.VCRTYPORI_0=10 and sto.VCRTYPREG_0 = 0 AND gope.CPLWST_0 NOT IN('22500L','22600L','225C0L','612B0l','611A0L','214G0','81000L','22050') and gope.CPLWST_0 is not null `

then i have second query :

`Select TOP 5 ITMMASTER.ITMREF_0, ITMMASTER.ITMDES1_0,ITMMASTER.TCLCOD_0, a3.TEXTE_0 from ITMMASTER join ITMCATEG cat ON ITMMASTER.TCLCOD_0= cat.TCLCOD_0 LEFT Join ATEXTRA a3 ON ITMMASTER.TCLCOD_0= a3.IDENT1_0 and a3.CODFIC_0 = 'ITMCATEG' and a3.ZONE_0='TCLAXX' AND a3.LANGUE_0='ENG' Where ITMMASTER.ITMREF_0 ='2AL00HR0' `

my question is how do i left join the two.?