CODEWITHSUNDEEP
mysqljoinleft-join
AM-
AM-

Reputation: 881

Unknown column even though the column exists

I get an error, Unknown column 'events.event_id' in 'field list' even though my table clearly has the column, as shown in the attached screenshot:

enter image description here

My SQL query is as follows:

SELECT
   `events`.`event_id`,
   `events`.`realm`,
   `events`.`starts`,
   `events`.`ends`,
   `general_data`.`id`,
   `general_data`.`nick`
FROM `events`
JEFT JOIN
   `general_data` ON `events`.`owner`=`general_data`.`id`
WHERE
   `instance`=1 AND
   `zone`=1 AND
   (`realm`='foo' OR `crossrealm`=1)
ORDER BY
   `events`.`starts`,`events`.`realm` ASC
LIMIT 0,50

Could anyone please offer some insight to what migh tbe causing this problem?

Upvotes: 1

Views: 967

Answers (1)

Jeremy
Jeremy

Reputation: 1521

JEFT JOIN

Did you type it wrong or? It should be LEFT JOIN i guess

Upvotes: 2

Related Questions