SQL question!
| From: | Bruno Braga | Date: | Tue, 04 May 2004 02:07:03 +0000 |
| Subject: | SQL question! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34260@lists.php.net to get a copy of this message | ||
Hey.
I have these tables.
Users ( id,name,etc )
Coments : ( id , comment )
How do I do this kind of query:
I thought in one thing like this but I cant figure it out.
Example: Select * from users order by id desc in (select count (id) from
comments)
Expected result:
List of users:
* User1
See comments ( 32 comment in database )
* User2
See coments (13 comments in database )
* etc.
thanks in advanced.
Bruno