+ Reply to Thread
Results 1 to 2 of 2

Thread: Error : unknown column in field list

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    15

    Error : unknown column in field list

    I am trying to make that query run , but i get an error that i do not understand , here is the query :
    Code:
    SELECT `Country.Name` as `CountryName`, `City.Name` as `CityName` FROM `Country`, `City` WHERE `Continent` = 'South America' AND `ID` = `Capital`;
    Error :
    Code:
    #1054 - Unknown column 'Country.Name' in 'field list'

  2. #2
    Junior Member
    Join Date
    May 2012
    Posts
    27
    The quotes are the problem , it should be like that :
    Code:
    SELECT
      `Country`.`Name` AS CountryName,
      `City`.`Name` AS CityName

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts