other mail wrote:
Executing the following query
SELECT tblLarger.* from tblSmaller JOIN tblLarger USING(id1,id2)
will only return columns in tblLarger that do not exist in tblSmaller.
For
example id1, id2 columns will not be returned.
Reordering the query will correctly return all columns in tblLarger
however
the query execution time is substantially slower...
Obviously, I could manually specify the columns as workaround but would
prefer not to...
I've tried this using sqlite version 3.3.4 and 3.3.8 and the seemingly
incorrect behavior is consistent...
Any help is appreciated
devo
Devo,
That is the way the SQL standard defines the USING clause to work. The
columns in the virtual table produced by the join can not be qualified
by either table name. The are columns in the output table only.
If you need the id columns displayed you must do this:
SELECT id1, id2, tblLarger.* from ...
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------