我有以下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
有谁知道我做错了什么?