Table doesn't exist

From SQLZOO
Revision as of 11:35, 19 July 2012 by Connor (talk | contribs)
Jump to: navigation, search
schema:gisq

Problem

An attempt was made to read from a table that does not exist.

Most likely the table name has been spelt incorrectly.

Possibly the table is not in the current schema or database.

Solutions

  • Correct the spelling of the table name.

</div>

SELECT * FROM Bbc
SELECT * FROM noSuchTable

</div>