Query Problems 'UNION'

[vbjohn]

I am getting this error:
Syntax Error (missing operator) in query expression

*-- = Start of the expression
--* = End of the expression

PARAMETERS [Begin Date] DateTime, [End Date] DateTime;
SELECT dbo_BIBUDINFO.DEPARTMNT, dbo_BIBUDINFO.DESCRIPTN, dbo_BIBUDINFO.BUDGETAMT, dbo_GL00100.ACTNUMBR_2,
dbo_GL00100.ACTNUMBR_3, dbo_GL20000.REFRENCE, dbo_GL20000.TRXDATE, dbo_GL20000.ORMSTRNM, dbo_GL20000.DEBITAMT
FROM (dbo_BIBUDINFO
INNER JOIN dbo_GL00100 ON dbo_BIBUDINFO.DEPARTMNT = dbo_GL00100.ACTNUMBR_2)
INNER JOIN dbo_GL20000 ON dbo_GL00100.ACTINDX = dbo_GL20000.ACTINDX
WHERE (((dbo_BIBUDINFO.DEPARTMNT)>'019') AND ((dbo_GL00100.ACTNUMBR_2)<>'026' And (dbo_GL00100.ACTNUMBR_2)<>'031' And
(dbo_GL00100.ACTNUMBR_2)<>'041' And (dbo_GL00100.ACTNUMBR_2)<>'102' And (dbo_GL00100.ACTNUMBR_2)<>'123') AND
((dbo_GL00100.ACTNUMBR_3)>'2000') AND ((dbo_GL20000.TRXDATE) Between [Begin Date] And [End Date]) AND
((dbo_GL20000.DEBITAMT)<>0))
UNION ALL SELECT dbo_BIBUDINFO.DEPARTMNT,dbo_BIBUDINFO.DESCRIPTN, dbo_BIBUDINFO.BUDGETAMT, dbo_GL00100.ACTNUMBR_2,
dbo_GL00100.ACTNUMBR_3, dbo_PM30200.TRXDSCRN, dbo_PM30600.PSTGDATE, dbo_PM00200.VENDNAME, dbo_PM30600.DEBITAMT *--
FROM (dbo_BIBUDINFO
INNER JOIN dbo_GL00100 ON dbo_BIBUDINFO.DEPARTMNT = dbo_GL00100.ACTNUMBR_2)
INNER JOIN dbo_PM30600 ON dbo_GL00100.ACTINDX = dbo_PM30600.DSTINDX
INNER JOIN dbo_PM00200 ON dbo_PM30600.VENDORID = dbo_PM00200.VENDORID
INNER JOIN dbo_PM30200 ON dbo_PM00200.VENDORID = dbo_PM30200.VENDORID AND dbo_PM30200.VCHRNMBR = dbo_PM30600.VCHRNMBR --*
WHERE (((dbo_BIBUDINFO.DEPARTMNT)>'019') AND ((dbo_GL00100.ACTNUMBR_2)<>'026' And (dbo_GL00100.ACTNUMBR_2)<>'031' And
(dbo_GL00100.ACTNUMBR_2)<>'041' And (dbo_GL00100.ACTNUMBR_2)<>'102' And (dbo_GL00100.ACTNUMBR_2)<>'123') AND
((dbo_GL00100.ACTNUMBR_3)>'2000') AND ((dbo_PM30600.PSTGDATE) Between [Begin Date] And [End Date]) AND
((dbo_PM30600.DEBITAMT)<>0));


Any help would be great, thanks.

John-

 

[RV]

This should be the SQL statement after UNION ALL:

SELECT dbo_BIBUDINFO.DEPARTMNT, dbo_BIBUDINFO.DESCRIPTN, dbo_BIBUDINFO.BUDGETAMT, dbo_GL00100.ACTNUMBR_2, dbo_GL00100.ACTNUMBR_3, dbo_PM30200.TRXDSCRN, dbo_PM30600.PSTGDATE, dbo_PM00200.VENDNAME, dbo_PM30600.DEBITAMT
FROM (((dbo_BIBUDINFO INNER JOIN dbo_GL00100 ON dbo_BIBUDINFO.DEPARTMNT = dbo_GL00100.ACTNUMBR_2) INNER JOIN dbo_PM30600 ON dbo_GL00100.ACTINDX = dbo_PM30600.DSTINDX) INNER JOIN dbo_PM00200 ON dbo_PM30600.VENDORID = dbo_PM00200.VENDORID) INNER JOIN dbo_PM30200 ON dbo_PM30600.VCHRNMBR = dbo_PM30200.VCHRNMBR
WHERE (((dbo_BIBUDINFO.DEPARTMNT)=[dbo_GL00100].[ACTNUMBR_2] And (dbo_BIBUDINFO.DEPARTMNT)>'019') AND ((dbo_GL00100.ACTNUMBR_2)<>'026' And (dbo_GL00100.ACTNUMBR_2)<>'031' And (dbo_GL00100.ACTNUMBR_2)<>'041' And (dbo_GL00100.ACTNUMBR_2)<>'102' And (dbo_GL00100.ACTNUMBR_2)<>'123') AND ((dbo_GL00100.ACTNUMBR_3)>'2000') AND ((dbo_PM30600.PSTGDATE) Between [Begin Date] And [End Date]) AND ((dbo_PM30600.DEBITAMT)<>"0") AND ((dbo_GL00100.ACTINDX)=[dbo_PM30600].[DSTINDX]) AND ((dbo_PM30600.VENDORID)=[dbo_PM00200].[VENDORID]) AND ((dbo_PM00200.VENDORID)=[dbo_PM30200].[VENDORID]) AND ((dbo_PM30200.VCHRNMBR)=[dbo_PM30600].[VCHRNMBR]));

Suc6,

RV

[This message has been edited by RV (edited 04-10-2002).]

 

[vbjohn]

thanks alot! it works now!