| Subject | RE: [firebird-support] subquery field in where phrase |
|---|---|
| Author | Alan McDonald |
| Post date | 2008-04-17T03:28:56Z |
> This is my sql:Use this instead
>
> select a.*,
> (select count(*) from a1 where a1.b_id = b.id) as F1
> from tb a
> where F1 = 100
>
> but it can't be executed. The error messsage is:
>
> Column does not belong to referenced table.
> Dynamic SQL Error.
> SQL error code = -206.
> Column unknown.
> F1
>
> Thank you.
> select a.*,Alan
> (select count(*) from a1 where a1.b_id = b.id) as F1
> from tb a
> where (select count(*) from a1 where a1.b_id = b.id) = 100