• Welcome, Guest. Please login.
 

slFn and multi-table selections with identical field/column names

Started by Bern Ertl, April 09, 2009, 07:01:00 pm

Previous topic - Next topic

Bern Ertl

It's not possible to use slFN to retreive data in scenarios like the following, correct?

SELECT T1.F1, T2.F1 FROM T1, T2

I would need to use slF with the column number, correct?  The column numbering is BASE 1, right?

Fred Meier

Yes, you can use slFN because "Select T1.F1, T2.F1 from T1, T2" is valid
to SQLite but will raise SQLitening error -13 (two columns with same name
of F1). 

Must add the AS clause on one or both "Select T1.F1 as T1F1, T2.F1 as
AnyName from T1, T2" and use the AS name in the slFN commands. 

Yes, column number is base 1 when you use the slF commands.