Du hast also originär 3 Abfragen, meinst du eventuell das hier?
SELECT VBSVORDT, VBSVORZT, VBSARTTX, VBSHNDKL, VBSURSLD, VBSPALMG, VBSPMENG, VBSFPMNG, VBSLGANR, arttx, VBSKUNNR, KUNNAME, VBSFOLNR, VBSFOLET, VBSKISZT, VBSECKL, VBSSANID, VBSSANKI, v1.PARLFD2 AS FolNr, v1.PARINHA1 AS FolTxt, v2.PARLFD2 AS EtikNr, v2.PARINHA1 AS EtikTxt FROM tbl_VBS JOIN tbl_KUN ON tbl_kun.KUNNR = tbl_vbs.VBSKUNNR JOIN tbl_ART ON tbl_art.ARTNR = tbl_vbs.VBSLGANR LEFT JOIN view_PAR v1 ON VBSFOLET = v1.PARLFD2 AND v1.KEYIPAR1 LIKE 'EVARFFOLIENNUMMER%' LEFT JOIN view_PAR v2 ON VBSFOLET = v2.PARLFD2 AND v2.KEYIPAR1 LIKE 'EVARFFOLIENETIKET%' WHERE VBSADRNR = '005256' AND convert(datetime,convert(char(10),VBSVORDT,104)) BETWEEN convert(datetime,convert(char(10),getdate(),104)) AND dateadd(dd,0,getdate())