There is a table of articles and a table of users in the database. We combine them with a JOIN so that the query shows both the articles and the users who wrote them. How now from this query select only one specific article, for example, with id = 1?

  • If you have a problem with two id fields in the sample, then you need to use table aliases: SELECT a.id, a.title, u.login FROM articles AS a LLT JOIN users AS u ON a.author = u.id WHERE a.id = 15 - etki
  • Thank you, everything worked as I wanted) - luminant

1 answer 1

Reply from comment:

SELECT a.id, a.title, u.login FROM articles AS a LEFT JOIN users AS u ON a.author = u.id WHERE a.id = 15