我有以下sql(Postgresql)查询：
SELECT ff.*,fp.* FROM fibra ff,fibra fp JOIN cables cp ON fp.cable_id = cp.id LEFT OUTER JOIN terceiro ced_pai ON ced_pai.id = cp.cedente_id LEFT OUTER JOIN terceiro tp ON tp.id = fp.terceiro_id JOIN cables cf ON ff.cable_id = cf.id LEFT OUTER JOIN terceiro ced_f ON ced_f.id = cf.cedente_id LEFT OUTER JOIN terceiro tf ON tf.id = ff.terceiro_id where ff.fibra_pai_id = fp.id AND ff.cable_id IN (8,9,10) AND fp.cable_id IN (8,10)
但它给我这个错误：
ERROR: invalid reference to FROM-clause entry for table "ff"
LINE 8: JOIN cables cf ON ff.cable_id = cf.id
^
HINT: There is an entry for table "ff",but it cannot be referenced from this part of the query.
********** Error **********
ERROR: invalid reference to FROM-clause entry for table "ff"
sql state: 42P01
Hint: There is an entry for table "ff",but it cannot be referenced from this part of the query.
Character: 261
有谁知道我做错了什么？
