SQL Server - Combine two select queries in sql ?
You could also do it in a single query using a join if UNION doesn't count for "single query":
SELECT s2.*
FROM Semester2 s2
LEFT OUTER JOIN Semester1 s1
ON s2.StudentId = s1.StudentId
AND s2.SubjectId = s1.SubjectId
WHERE s1.StudentId IS NULL; The WHERE clause will make it so only results where there isn't a perfect match in Semester1 appear.
85 0 7
Write a Comments
* Be the first to Make Comment
In Offer
Livpure Smart Solid Window Polyester 5 feet Curtains with tieback( Beige ) Set of 2
Van Heusen Antibacterial Non Padded Non Wired Slim Fit Cotton Bra
Van Heusen Women's Cotton Printed Anti-Bacterial Bikini (Pack of 3)
Croma 1 Ton 3 Star Split Fixed Speed AC (Copper, Blue Fins, PM 2.5 Filter with activated carbon, R-32 Green Refrigerant, 2022 Model, 5 Years Compressor Warranty, CRAC7721, White)
SHOWTIME Gift for Husband Special Romantic Gift for Wife
Underwear Comfortable fit Throughout Pregnancy
Suson Men Synthetic Lace Up Formal/Office/Casual/Derby Shoes
SBAPRIME 3pcs-Set Men's Gift Set Men and Boys Watch, Cap & Sunglasses Combo Set Birthday Present
ZISAAN Latest Striped Sleeve[Less Summer Gift TOP for Women & Girls (Blue, Small)
Sillyboom Maternity Boy Peeking T-Shirt for Pregnant Women
Recent Posts
HOW SEO CAN BOOST BRAND A...
Tips for design the new w...
5 Most Useful Tips for Em...
Best Software Outsourcing...
Essential marketing tools...
5 Most Useful Tips and tr...
Creating Law Websites tha...
Why Web Design Is the Hea...
5 Tips to choose the best...
Advantages of having a we...
Contact Details
(+91) 81306 40 966
(+91) 78277 51662
live:trimwebsolutions
New Delhi, India
