Sql examination questions, how to write, ask for advice!

is like this, and the ultimate effect is to match the avatar address of the drink in the user table for each comment list

first, query out the table_1 (article comment table) article comment result set

then I found that these comments do not have user avatars, so I need to associate the table_2 (user table) of the query. In this place, the reply_user in the result set of the first comment query is associated with the username in the table_2 (user table).

the user avatar to be queried is in the avatar_link field of table_2 (user table)

then merge the list of comments and the corresponding avatar (each comment corresponds to a different user avatar)

solve the problem, sql is not good at learning

Mysql sql oracle

Mar.13,2021

--sql

SELECT a.*,b.avatar_link

FROM [dozhan_reply] a

INNER JOIN [dozhan_user] b ON a.reply_user = b.username

WHERE a.reply=69

related queries can't you? In addition, it is best to use the text to describe the problem. It looks convenient for

to describe the problem vaguely. The avatar address should be returned in the picture, and the text expression should be returned as well.
if the former, go to the top floor, make an association query, and then return avatar_link. For details, see https://bbs.csdn.net/topics/3.

is the most basic join query. Refer to SQL's four join queries

Note that the article is SQL Server syntax. You can find out how to write the syntax of MySQL .

Previous: After discuz has activated https, the loading of plate icons is very slow.

Next: Idea does not compile aspectj files

What is wrong with this section of sql and how to solve it?
(SELECT * FROM `dozhan_reply` t1 WHERE `reply_parent` IN ( SELECT `reply_id` FROM ( SELECT `reply_id` FROM `dozhan_reply` WHERE `reply_article` = 69 AND `reply_type` = 0 LIMIT 0, 5 ) t )) UNION (SEL...

Mysql sql oracle

Mar.12,2021
Solving sql Association query
SELECT * FROM `table_1` WHERE `reply_parent` IN (SELECT `reply_id` FROM (SELECT `reply_id` FROM `table_1` WHERE `reply_article`=69 AND `reply_type`=0 LIMIT 0, 5)AS t) UNION (SELECT * FR...

Mysql sql oracle nosql redis

Mar.12,2021
How to realize multi-table union search?
the structure of the table is as follows: now I need to query the contents from different tables according to the user s input. How can I quickly and effectively find out the results I want? my idea is to associate the three tables, use case.whe...

Mysql sql oracle sqlserver postgresql

May.06,2021
How to use a msyql statement to put several tables with the same table structure into a table and finally export it?
I now have multiple tables that generate one table every day from July 1 to December 30, and now my boss asks me to summarize the table contents of each month. The database table is just like in the picture. I wonder if it is possible to use a SQL state...

Mysql sql oracle

Jan.08,2022