Mega Code Archive
Qualify the column name with table name and database name
CREATE TABLE TEAMS
(TEAMNO INTEGER NOT NULL,
EmployeeNO INTEGER NOT NULL,
DIVISION CHAR(6) NOT NULL,
PRIMARY KEY (TEAMNO) );
INSERT INTO TEAMS VALUES (1, 6, 'first');
INSERT INTO TEAMS VALUES (2, 27, 'second');
SELECT TENNIS.TEAMS.TEAMNO
FROM TENNIS.TEAMS;
drop table teams;