QUERY RETURNS?

HI
QUERY SHOULD RETURNS NON MATCHING ROWS REGARDLESS OF PAYMENTID REGARDING THE PARTICULAR DATE..THAT IS NEED..BUT IS THIS QUERY POSSIBLE?
PLEASE MAKE IT CORRECT

select tblpayments.ipaymentid,tblpayments.vpayment,tblpayments.dbilldate from

(select tblpayments.ipaymentid,tblpayments.vpayment,tblpayments.dbilldate from tblpayments union select tblexpense.expname,tblexpense.expamount from tblexpense)

LEFT JOIN tblpayments on tblpayments.ipaymentid=tblexpense.ipaymentid and dbilldate='2014-09-03'

LEFT JOIN tblexpense on tblpayments.ipaymentid = tblexpense.ipaymentid and dbilldate='2014-09-03'

where tblexpense.dbilldate='2014-09-03'

ERROR FOUND:
Msg 156, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'LEFT'.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Abhishek Kumar12y ago
Accepted answer
Hi,

Union statement is not correct , if you want to use union you need to have same columns in select .

incorrect syntax.

select tblpayments.ipaymentid,tblpayments.vpayment,tblpayments.dbilldate from tblpayments
union
select tblexpense.expname,tblexpense.expamount from tblexpense

Hope this will help.

Abhishek