D
D
dron88862020-11-13 09:59:15
SQL
dron8886, 2020-11-13 09:59:15

How should a sql query from two tables (join) look like?

5fae2e992e758253723096.png

display the title, description, and year of all books where the author is Roma

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Rsa97, 2020-11-13
@Rsa97

SELECT что_выбрать
  FROM таблица1
  JOIN таблица2 ON условие_соединения
  WHERE условие_выборки

V
Vasily Bannikov, 2020-11-13
@vabka

This is a task, not a question.

SELECT b.title, b.year
FROM BOOKS b
  JOIN USER u on b.uid = u.id
WHERE
  u.name = 'Рома'

PS: here the naming of the fields in the tables should be corrected

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question