View Single Post
Old 11-06-2009, 04:04 AM   #6 (permalink)
rguy84
The Contributor
 
Join Date: Jun 2009
Location: Seattle, WA
Posts: 76
Thanks: 1
rguy84 is on a distinguished road
Default

I am not understanding what you are saying at all. Can you provide sample data, and what your result should look like?

Why would you use 3 queries to get data from one table, that seems terribly ineffient. Look into SQL Case (they are like if/else loops)...
__________________
Ryan | Blog | Twitter
Send a message via AIM to rguy84 Send a message via MSN to rguy84 Send a message via Yahoo to rguy84 Send a message via Skype™ to rguy84
rguy84 is offline  
Reply With Quote