|
|
Posted by none on 09/29/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
Navigation:
[Reply to this message]
|