Re: Re[2]: [sqlite] Help me in SQL

On 7/23/06, blins <[EMAIL PROTECTED]> wrote: Hi Jay, Friday, July 21, 2006, 7:05:59 PM, you wrote: JS> Can you change the alias to a different field name than the source tables? I try: select t1.field1 as otherfield1, t2.field2 as otherfield2 from table1 t1 left join table2 t2 on (t1.id

Re[2]: [sqlite] Help me in SQL

Hi Jay, Friday, July 21, 2006, 7:05:59 PM, you wrote: JS> Can you change the alias to a different field name than the source tables? I try: select t1.field1 as otherfield1, t2.field2 as otherfield2 from table1 t1 left join table2 t2 on (t1.id=t2.refid) and I receive the message on a mista

Re: [sqlite] Help me in SQL

Can you change the alias to a different field name than the source tables? On 7/20/06, blins <[EMAIL PROTECTED]> wrote: Hi [email protected], I use sqliteODBC 0.68 + ADO and SQLite 3.3.6. I try executing sql: select t1.field1 as field1, t2.field2 as field2 from table1 t1 left join tabl

[sqlite] Help me in SQL

Hi [email protected], I use sqliteODBC 0.68 + ADO and SQLite 3.3.6. I try executing sql: select t1.field1 as field1, t2.field2 as field2 from table1 t1 left join table2 t2 on (t1.id=t2.refid) and I receive the message on a mistake "no such column: t1.field1(1)" -- Компьютеры помогают