On 5/16/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
> SELECT c1, c2, c3 FROM a JOIN b USING(c1); > > Preparing this returns SQLITE_ERROR with message "ambiguous column name: c2". >
This is wrong. Column c2 only exists in table b and so it can't be
ambiguous. I suspect you are using different table definitions than I gave.
This should say that column c2 only exists in table a of course. I thought I'd better mention this typo before it leads to further confusion. Dennis Cote