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
Shaik Ali
NA
46
955
Converting two Select Querys into One Query
Jun 28 2019 12:17 AM
Dear Experts
Can you please suggest
How do i Convert the following two queries into one query
(SELECT SUM(Qty+QtyFree) AS TOT_IN
FROM detail AS D
WHERE TTYPE IN ('P','R','T')
GROUP BY BID),
(SELECT SUM(Qty+QtyFree) AS TOT_OUT
FROM detail
WHERE TTYPE IN ('S','B','A')
GROUP BY BID)
THANKS
Reply
Answers (
5
)
Converting nested JSON string into csv
Getting Error on server?