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

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