Carlos H. Cantu wrote:

>Am I too tired or the second SQL you posted is invalid ?
>
>Anyway, take care since in FB subqueries can be very slow. You must,
>always as possible, write your SQL using JOINs.
>
>Carlos
>http://www.warmboot.com.br
>FireBase - http://www.FireBase.com.br
>
>
>
>

Carlos,

I think he just mistyped the table name

>d> SELECT TABLE_A.field1
>d> from TABLE_A
>d> inner JOIN TABLE_A on TABLE_A.joinfield = TABLE_B.joinfield
>
>

SELECT TABLE_A.field1
from TABLE_A
inner JOIN TABLE_B on TABLE_A.joinfield = TABLE_B.joinfield

^

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br