hi

Please support our C# advertiser: Intel Parallel Studio Home
Reply

Join Date: Nov 2008
Posts: 128
Reputation: sivak has a little shameless behaviour in the past 
Solved Threads: 0
sivak sivak is offline Offline
Junior Poster

hi

 
0
  #1
Nov 15th, 2008
hi all
i have one employee table ..it contains 2 coloums like employee name and manager...
every employee have manager ...that manager also one of the employee...some employee dosnt have manager on that table...
i want to write the query who dosent have manager on that table?
Reply With Quote Quick reply to this message  
Join Date: Oct 2007
Posts: 172
Reputation: Jugortha is an unknown quantity at this point 
Solved Threads: 16
Jugortha Jugortha is offline Offline
Junior Poster

Re: hi

 
0
  #2
Nov 15th, 2008
you can use a left join query to the table it self
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 128
Reputation: sivak has a little shameless behaviour in the past 
Solved Threads: 0
sivak sivak is offline Offline
Junior Poster

Re: hi

 
0
  #3
Nov 16th, 2008
shall i do left join in one table? i used left join for joining 2 tables ...can u tell me how it is possible?
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC