TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Maneesh A N
NA
179
108.5k
QUERY RETURNS?
Sep 25 2014 2:48 AM
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'.
Reply
Answers (
1
)
What is the code to copy a file to a system32 folder
Radiobuttons true with the string using listview