943,744 Members | Top Members by Rank

Software Development > C# > hi
Ad:
  • C# Discussion Thread
  • Unsolved
  • Views: 520
  • C# RSS
Permalink
Nov 15th, 2008
0

hi

Expand Post »
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?
Reputation Points: 3
Solved Threads: 0
Junior Poster
sivak is offline Offline
132 posts
since Nov 2008
Permalink
Nov 15th, 2008
0

Re: hi

you can use a left join query to the table it self
Reputation Points: 11
Solved Threads: 16
Junior Poster
Jugortha is offline Offline
172 posts
since Oct 2007
Permalink
Nov 16th, 2008
0

Re: hi

shall i do left join in one table? i used left join for joining 2 tables ...can u tell me how it is possible?
Reputation Points: 3
Solved Threads: 0
Junior Poster
sivak is offline Offline
132 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in C# Forum Timeline: Crystal Report shows only one column from the Data Table
Next Thread in C# Forum Timeline: Searching for specfic strings in a splitted plsfile?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC