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?
sivak -7 Junior Poster
Jugortha -1 Junior Poster
you can use a left join query to the table it self
sivak -7 Junior Poster
shall i do left join in one table? i used left join for joining 2 tables ...can u tell me how it is possible?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.