Hi,

This is my sql:

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.