Click here to Skip to main content
12,458,155 members (54,132 online)
Click here to Skip to main content

Stats

0 views
Posted

better sp to get unmatched records?

, 5 Feb 2013 CPOL
Method 1: Get a resultset with common 'Furniture' and 'Machinery' and use that in a subquery to exclude those results.SELECT Flat, Land FROM tblPropertyWHERE Furniture NOT IN (SELECT Furniture FROM tblProperty pINNER JOIN tblSales s ON p.Furniture = s.Furniture AND p.Machinery =...

Revisions


  

Compare Revision Minor Date Status Editor
2 - publicly available No 6-Feb-13 0:57 Available Ankur\m/
grammar/language
1 No 6-Feb-13 0:43 Available Ankur\m/

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Ankur\m/
Technical Lead Ignify Inc.
India India
I wanna travel the universe and beyond that!

You may also be interested in...

Pro
Pro
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160826.1 | Last Updated 6 Feb 2013
Article Copyright 2013 by Ankur\m/
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid