Quote:
Originally Posted by mrevent
I add ',timestamp' to the sequence above but terminal does not accept 'timestamp'
|
AFAIK, you'll have to add the table name if a column name exists in multiple tables (
LOOKUPS.timestamp or
WORDS.timestamp). For example:
Code:
SELECT WORDS.lang, word, stem, usage, authors, title, category, LOOKUPS.timestamp FROM LOOKUPS JOIN WORDS on LOOKUPS.word_key=WORDS.id JOIN BOOK_INFO on LOOKUPS.book_key=BOOK_INFO.id