INNER JOIN???

[Naoise]

JOINS, my Achilles heel

tblFoo
---------
FooID [int] | Foobar [varchar] | HasQuota [int] | Quota [int] | Stock [int]

How would I get all values from tblFoo based on a certain quantity value? If the record has a quota then I check to see that quantity <= stock, if the record has no quota then return it as part of the result set. Any help appreciated.

 

[AlexCuse]

I'm not sure that you need a join for this. Where is the quantity value coming from?

Here is a guess (assumes 0 in HasQuota means there is not a quota):

select * from tblFoo
where HasQuota = 0
or quota < Stock

HOpe this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[r937]

where do you see a join coming into this?

why even have the HasQuota column? why not just let Quota be NULL?

and where is this Quantity coming from, which must be less than or equal to Stock?

r937.com | rudy.ca