Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
A
A
Artem Chirkov2019-12-20 23:09:15
SQL
Artem Chirkov, 2019-12-20 23:09:15

Need to create a sql query to create a report.?

5dfd26ea45e85456726452.png
5dfd28d5cc2d3018885681.png
1) publishing house and books that relate to them
2) Did it 3) it also seems to be like that, but with 1 problemSELECT FIO,Author,Name FROM `book`

SELECT genre.Genre,Author,Name,Tom FROM book INNER JOIN genre ON book.Genre = genre.idGenre

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
I
islam-4042021-09-21 23:38:59
How to upload several files (photos) to the database at once through the site? 1Reply
S
Stanislav2016-02-09 21:30:03
SQL query. How to select records with 2 older parents but no children? 1Reply
N
Nikolaymac2018-06-26 14:05:32
How to speed up a SELECT query with nested queries? 2Reply
R
rusel009 -2021-09-24 15:03:22
How to form a correct query in SQL? 1Reply
T
Theory Theory2020-06-29 07:10:39
Where to learn sql and mysql? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question