Re: [sqlite] SQL-92 Syntax Question

On 9/7/07, Brad Stiles <[EMAIL PROTECTED]> wrote: > > Anyway, if I understand what you're saying, I believe what you want is an > OUTER JOIN. > > SELECTT1.COLUMN, T2.COLUMN > FROM TABLE2 T2 > outer join TABLE1 T1 on T2.COLUMN = T1.COLUMN > > That will get all rows from T2, and

Re: [sqlite] SQL-92 Syntax Question

> SELECTT1.COLUMN, T2.COLUMN > FROM TABLE1 T1, TABLE2 T2 > WHERE T1.COLUMN *= T2.COLUMN Sorry about the fist one. New web mail client... Anyway, if I understand what you're saying, I believe what you want is an OUTER JOIN. SELECTT1.COLUMN, T2.COLUMN FROM TABLE2 T2

Re: [sqlite] SQL-92 Syntax Question

> The SELECT I have is: > > SELECTT1.COLUMN, T2.COLUMN > FROM TABLE1 T1, TABLE2 T2 > WHERE T1.COLUMN *= T2.COLUMN > > In SQL Server, the *= indicates a forced inner join which would cause > a record to be generated regardless if it existed in the T1 table or > not. If I

[sqlite] SQL-92 Syntax Question

I learned SQL before the SQL-92 standard was in place. The database engines I used (SQL Server and Oracle) have their own proprietary methods for indicating forced inner outer joins. I haven't looked at this code in over 10 years, so I'm a little unclear about exactly what the result set