retriving values from two tables
| From: | karthikeyan | Date: | Tue, 19 Nov 2002 17:22:29 +0000 |
| Subject: | retriving values from two tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23485@lists.php.net to get a copy of this message | ||
Hi all,
I am karthik. I am using using php with mysql. i am stuck with a qury. Pls hep me out.
i have two tables. Here is table with sample data
Table Name : Links
linkid header
1 yahoo.com
2 google.com
3 php.net
4 sai.org
5 mysql.net
Table Name : subLinks
linkid childid
1 2
3 5
4 3
I want to fetch the linkid and header from links table based on condition that i select only the
main links. which are not under any link
In our example it is
1 and 4
Pls help out with the query..Its Urgent
Thanks
Jai Sairam
Karthikeyan.S
---------------------------------
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site