SQL join subquery(SQL 连接子查询)

Will this (normalised) database structure permit me to search by tags as I intend?(这个(规范化的)数据库结构是否允许我按照我的意图按标签进行搜索?)

Can someone recommend a good tutorial on MySQL indexes, specifically when used in an order by clause during a join?(有人可以推荐一个关于 MySQL 索引的好教程，特别是在连接期间在 order by 子句中使用时?)

MySQL FULL JOIN not working but RIGHT and LEFT join works(MySQL FULL JOIN 不工作，但 RIGHT 和 LEFT 连接工作)

Does EXCEPT execute faster than a JOIN when the table columns are the same(当表列相同时，EXCEPT 的执行速度是否比 JOIN 快)

MySQL UPDATE with SELECT SUM from different table(MySQL UPDATE 与来自不同表的 SELECT SUM)

What#39;s the best way to use LEFT OUTER JOIN to check for non-existence of related rows(使用 LEFT OUTER JOIN 检查相关行不存在的最佳方法是什么)

Problems with INNER JOIN and LEFT/RIGHT OUTER JOIN(INNER JOIN 和 LEFT/RIGHT OUTER JOIN 的问题)

MySQL Limit LEFT JOIN Subquery after joining(MySQL限制LEFT JOIN加入后的子查询)

MYSQL join comma separated query(MYSQL 连接逗号分隔查询)

How to FULL OUTER JOIN multiple tables in MySQL(如何在 MySQL 中完全 OUTER JOIN 多个表)

SQL to find duplicate entries (within a group)(SQL 查找重复条目(组内))

How to update from select with a Join(如何使用加入从选择更新)

SQL Joins: Future of the SQL ANSI Standard (where vs join)?(SQL 连接:SQL ANSI 标准的未来(where 与 join)?)

mySQL - Insert into three tables(mySQL - 插入三个表)

hotel reservation system SQL query: identify when one specific room is available(酒店预订系统 SQL 查询:确定某个特定房间何时可用)

MySQL sum, count with group by and joins(MySQL 总和，用 group by 和 join 计数)

How to create select dynamic fields from a table in mysql?(如何从mysql中的表中创建选择动态字段?)

Join table depending on value of column in main table(根据主表中列的值连接表)

What type of JOIN to use(使用什么类型的 JOIN)