Ok thanks.
Transaction_id is defined twice, one from transaction table another
from entries:
ProgrammingError: (ProgrammingError) column reference "transaction_id"
is ambiguous
LINE 5: ...winancial_integ.acc_transactions.transaction_id =
aaa.transa...
^
'DELETE FROM winancial_integ.acc_transactions WHERE EXISTS (SELECT 1
\nFROM (SELECT winancial_integ.acc_transactions.transaction_id AS
transaction_id, winancial_integ.acc_transactions.value_date AS
value_date, winancial_integ.acc_transactions.code AS code,
winancial_integ.acc_transactions.description AS description,
acc_entries_1.entry_id AS entry_id, acc_entries_1.account_id AS
account_id, acc_entries_1.transaction_id AS transaction_id
On May 13, 5:05 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On May 13, 2008, at 11:03 AM, jean-philippe dutreve wrote:
>
>
>
> > I've this error:
> > ProgrammingError: (ProgrammingError) subquery in FROM must have an
> > alias
> > HINT: For example, FROM (SELECT ...) [AS] foo.
> > 'DELETE FROM winancial_integ.acc_transactions WHERE EXISTS (SELECT 1
> > \nFROM (SELECT winancial_integ.acc_transactions.transaction_id AS
> > transaction_id, ...
>
> hi, then just call statement.alias() to make it into an alias.
>
> - mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
