Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Issue of Self join

Author  Topic 

rupalim
Starting Member

20 Posts

Posted - 2010-10-08 : 07:21:46
Hi,
I have a query in that i have to retrieve the data of the employees who belong to 'HR-Dept' ,so how is it possible ,the value through front -end must show only the employees who are 'HR'

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-10-08 : 07:24:55
What have you come up with so far? Some of us here will do your homework for you, but most of us require some effort on your part. Review your notes on the WHERE clause and then give the query another try.

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

kunal.mehta
Yak Posting Veteran

83 Posts

Posted - 2010-10-11 : 03:38:07
what is the table structure? do u have any test data or expected results?
Go to Top of Page
   

- Advertisement -