Joshua D. Drake <[EMAIL PROTECTED]> schrieb: > salman Sheikh wrote: >> >> >> Hi freinds, >> i wanted to add my all tables once in MFC application, >> >> i have a databank,which has 11 tables and i want to add them all togather. >> >> After Adding all tables, it shows me always this errors by debugging. >> >> >> ERROR: column reference "ctid" is ambiguous; >> Error while executing the query > > This means you did this: > > SELECT ctid,ctid from table1, table2 > > But it doesn't know which ctid belongs to which table. You need to use > aliases or dotted notation.
For the example above, for instance: select a.ctid, b.ctid from table1 a, table2 b ... (if you want this columns) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
