microtrain / bootcamp

Courseware for MicroTrain's Dev Bootcamp
17 stars 39 forks source link

Errors in 10-MySQL #3

Closed JeBuSBrian closed 5 years ago

JeBuSBrian commented 5 years ago

03-WorkingWithMySQL.md

Current code:

SELECT 
  posts.title,
  CONCAT(first_name, ' ', last_name) AS author
FROM 
  posts, 
  users 
WHERE 
  posts.created_user_id = users.id ;

Correct code:

SELECT 
  posts.title,
  CONCAT(first_name, ' ', last_name) AS author
FROM 
  posts, 
  users 
WHERE 
  posts.user_id = users.id ;
swasgrafx commented 5 years ago

Removed created_