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.