przy wykonaniu zapytania
SELECT consols.inv_number, bars.name, consols.inv_number, SUM(payments.value_pln) value_pln FROM payments, consols, payment_types LEFT JOIN localizations ON (localizations.consols_id = consols.id) LEFT JOIN bars ON (bars.id_bars = localizations.bars_id) WHERE payments.consol_id = consols.id AND payment_types.id = payments.payment_type_id GROUP BY consols.id, consols.inv_number, bars.name
dostaje
Kod
ERROR: invalid reference to FROM-clause entry for table "consols"
LINE 3: ...JOIN localizations ON (localizations.consols_id = consols.id...
LINE 3: ...JOIN localizations ON (localizations.consols_id = consols.id...
a jak przeniose do JOIN tą tabele
SELECT consols.inv_number, bars.name, consols.inv_number, SUM(payments.value_pln) value_pln FROM payments, consols LEFT JOIN localizations ON (localizations.consols_id = consols.id) LEFT JOIN bars ON (bars.id_bars = localizations.bars_id) LEFT JOIN payment_types ON (payment_types.id = payments.payment_type_id) WHERE payments.consol_id = consols.id GROUP BY consols.id, consols.inv_number, bars.name
to dostaje
Kod
ERROR: invalid reference to FROM-clause entry for table "payments"
LINE 5: LEFT JOIN payment_types ON (payment_types.id = payments.paym...
LINE 5: LEFT JOIN payment_types ON (payment_types.id = payments.paym...
może mi ktoś wytłumaczyć co robię źle