sql query

[gm000]

i have two tables one submittable and 2nd commenttabe
submittabls has field

ID
URLID
URLADDRESS
USERNAME
DATETIME

2nd table(commentta ble)

URLID
COMMENTID
TEXT

Now i want single query which show submittable records and count commentid form commenttable.

Please help me.

[Atli]

Hey.

To do that, you could use either a JOIN or a Subquery.

For example, say I had a News table and a NewComment table, where the comments were link to the news by a Foreign Key on the News id column.

Using a Subquery, I could get the news info and count the number of comments for it by doing:
[code=sql]
SELECT
n.`id`, n.`headline`, n.`body`, n.`author`,
(SELECT COUNT(*)
FROM `news_comments` AS nc
WHERE nc.`news_id` = n.`id`
) AS 'comments'
FROM `news` as n
[/code]