Problem with self join
| From: | suneel | Date: | Mon, 29 Nov 2004 08:42:23 +0000 |
| Subject: | Problem with self join | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-203053@lists.php.net to get a copy of this message | ||
Hi...
Please take a look at the following...
I'm using MySQL 4.0.15
I have the database like this....
Id name Owner
1 Top Menu 0
2 File 1
3 Open 1
4 Text File 2
5 Dot Net 2
6 ASP.Net 5
7 C#.Net 5
In the above data the Id's 6 & 7 are not owner to any one.So,I
want to retrieve those Id's which are not owner to any one.
Thanks in advance,
With Cheers,
Sun.