One query?

[tsp1lrk72]

How can i put this into one query?

Select  *
From	tblVendorInfo 
where	RankComplete IS NOT NULL AND DivisionName = 'BP'
Order by RankComplete

Select  *
From	tblVendorInfo 
where	RankInProgress IS NOT NULL AND DivisionName = 'BP'
Order by RankInProgress

Select  *
From	tblVendorInfo 
where	RankProblem IS NOT NULL AND DivisionName = 'BP'
Order by RankProblem

When I use AND for each one it shows nothing, example:

Select  *
From	tblVendorInfo 
where	RankComplete IS NOT NULL AND RankInProgress IS NOT NULL AND DivisionName = 'BP'
Order by RankComplete

Subquery?

 

[gmmastros]

Probably.... OR. Like this...

Select  *
From    tblVendorInfo
where   DivisionName = 'BP'
        And (RankComplete IS NOT NULL OR RankInProgress IS NOT NULL)
Order by RankComplete

The parenthesis are important.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom