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
