Database

select empmst.empcode, empmst.empname, refvalue_1.description as designation, ref_value_2.description as department
from empmst inner join refvalue refvalue_1
on empmst.desigcode = refvalue_1.value
inner join refvalue refvalue_2
on empmst.deptcode = refvalue_2.value

select studentname
from studentmaster
where not exists
(select top 1 *
from feesregister
where regisrationnumber = studentmaster.registrationnumber
and feesofmonth='march' 
and session='2007-2008' 
and class='3' 
and section='a')

s.sathyanarayanan wrote:

can any of you tell me how to retrieve the no of records fetched thru a
fulltext CONTAINS query??

s.sathyanarayanan wrote:

select * from tablename where CONTAINS(Username,'Keyword')

.CS wrote:

select *

John Mecas wrote:

select * statement should return only those columns which don`t contain a NULL value

<br />
select name,isnull(occupation,'yadayadayada'),age<br />
from persons<br />
where occupation <> 'yadayadayada'

<br />
select name,occupation,age<br />
from persons<br />
where occupation is not null

LyndonJohn wrote:

the user can search for the different products