I'm not clear on what you're considering the 'main links'. You can use the linkid value to match the header in the Links table to the childid in the subLinks table.
SELECT Links.header, subLinks.childid FROM Links, subLinks WHERE Links.linkid = subLinks.linkid; This should return values like this: ------------------------- | header | childid| ------------------------- | yahoo.com | 2 | | php.net | 5 | | sai.org | 3 | ------------------------- You could narrow down the results returned by adding WHERE subLinks.childid = $value in your query. Hope this helps! Shannon Johnston On Tue, 2002-11-19 at 10:22, karthikeyan wrote: > > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
