MySQL does not support subqueries (which is what your inner SELECT is), 
Temp tables, procs or transactions.

regards
David Cameron
nOw.b2b
dcameron@i...

> -----Original Message-----
> From: jhd67@v... [mailto:jhd67@v...]
> Sent: Friday, 14 February 2003 7:10 AM
> To: sql language
> Subject: [sql_language] Error on SQL Syntax
>
>
> I ams witching from access to MYSQL, but having a hard time
> with the query
> on MYSQL. All though everything works fine in  access ,
> Please Help Thank
> you
>
> SQL-query : 
> SELECT CATS.CAT_ID, CAT_NAME, CAT_IMAGE, (SELECT COUNT (*)  FROM ADS 
> WHERE ADS.CAT_ID =3D CATS.CAT_ID AND AD_APPROVED =3D 1 AND
> AD_EXPIRED > DATE
> () ) AS TOTAL  FROM CATS  WHERE cat_name like '" + Replace
> (rsCat__varcat_name, "'", "''") + "%'  ORDER BY CAT_NAME ASC
> LIMIT 0, 30
>
>
> MySQL said:
>
>
> You have an error in your SQL syntax near 'SELECT COUNT (*) 
> FROM ADS 
> WHERE ADS.CAT_ID =3D CATS.CAT_ID AND AD_APPROVED =3D 1 A' at line 1
>
>
> Next One:
> ___________________________________________________
>
> SQL-query :  [Edit]
>
> SELECT *,(SELECT COUNT (*)  FROM ADS  WHERE ADS.Type_ID =3D
> Types.Type_ID
> AND AD_APPROVED =3D 1 AND AD_EXPIRED > DATE()) AS TOTAL  FROM
> TYPES  ORDER
> BY TYPE_NAME ASC LIMIT 0, 30
>
>
> MySQL said:
>
>
> You have an error in your SQL syntax near 'SELECT COUNT (*) 
> FROM ADS 
> WHERE ADS.Type_ID =3D Types.Type_ID AND AD_APPROVED =3D ' at line 1
>