Subject subquery field in where phrase
Author tailuo2002

This is my sql:

select a.*,
(select count(*) from a1 where a1.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.

Thank you.