Posted by none on 10/14/42 11:30

On Thu, 27 Oct 2005 00:54:42 +0100, in alt.php.sql you wrote:


>What I have is
>select t1.count(*) as count,t2.*, from t1,t2 order by count
>
>But that gives me an error pointing to (*)
>
>Can anyone give me the proper syntax plus explanation.. please:)


damm forgot the where
ID=x

select t1.count(*) as count,t2.* from t1,t2 where t1.id=ID and
t2.id=ID order by count

[Back to original message]