New topic: Need help with exclusive query
<http://forums.realsoftware.com/viewtopic.php?t=46344> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message Dale Post subject: Need help with exclusive queryPosted: Tue Dec 25, 2012 1:22 am Joined: Thu Mar 01, 2007 2:02 pm Posts: 214 Location: Sunny (generally!) Southern California Well, either it's the season or old age creeping in on me again but I'm having trouble coming up with a sql query that I really should know. Basically, I have two tables in the RealSqlDatabase. (There are actually more but only these two are involved at the moment.) One table has a complete set of data in one of its columns while the other table has a partial set in its column. What I am trying to remember is a simple sql query to retrieve the data that is in column 1 but is NOT in column 2. Right now, I'm using a NOT IN clause mated with a sub-select but there's got to be a better way to do it. Isn't there? Thanks. - Dale _________________ ----- Real Studio 2012r1 on Windows 7 (64 bit) ----- It has been said that politics is the second oldest profession. I have learned that it bears a striking resemblance to the first. - Ronald Reagan Top timhare Post subject: Re: Need help with exclusive queryPosted: Tue Dec 25, 2012 4:14 am Joined: Fri Jan 06, 2006 3:21 pm Posts: 11911 Location: Portland, OR USA Use NOT EXISTS with a subquery. Or use a join and select for WHERE table2.column1 IS NULL. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
