sql query with alias name
Posted
by Ranjana
on Stack Overflow
See other posts from Stack Overflow
or by Ranjana
Published on 2010-05-31T13:06:36Z
Indexed on
2010/05/31
13:12 UTC
Read the original article
Hit count: 205
i have a table with this columns--- Or
orgid ispaid validity noofthingstoTake 1 yes 2010-06-05 20 2 yes 2010-06-09 7
i have used this query(to join two more tableS):
select distinct B.RequirementID,A.OrganizationID
from
Organization A,RequirementsDetailsforOrganization B,validityorgdet F
where A.OrganizationID=B.OrganizationID and F.orgid=A.OrganizationID and
F.ispaid=1 and F.validity>=GETDATE() and
F.noofthingstoTake> ??
but i dont know how to check the (noofthingstaken) over here. it should not exceed 20. im passing this query from my code behind page to the Sql. how to get the query excute to check it should not exceed the noofthingstaken
pls help me out....????
© Stack Overflow or respective owner