View Single Post
Old 09-30-2003, 07:27 PM  
swedguy
Confirmed User
 
Industry Role:
Join Date: Jan 2002
Posts: 7,981
Quote:
Originally posted by magnatique
I edited my post, basically for the second part I need to do a left join and test if it's null, or bigger than something...



---

mr thumbs, I know how I could do it doing 5 queries on the page....


I'm trying to find out if there's a way I could combine it all in one....
I didn't really follow you in your first post. But if you only need to do those tests.....

SELECT ...... WHERE row IS NULL OR row > 100
swedguy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote