SQLite

The following SQL gives a "no such column" error while parsing the second query:

CREATE TABLE t1(a PRIMARY KEY) WITHOUT ROWID;
INSERT INTO t1 VALUES('abc');
CREATE TABLE t2(x);
INSERT INTO t2 VALUES('xyz');
SELECT t2.rowid FROM t1, t2; -- works
SELECT t2.rowid FROM t2, t1; -- "no such column" error

Note that the error only arises if the second of the two tables in the join is a WITHOUT ROWID table.