MySQL SELECT two tables while substituting the values of a first table's field with the values of the second table's field
35704
How do you join on the same table, twice, in mysql?
9555
MySQL how to join tables on two fields
74632
Query without having to specify table's schema
151103
mysql extra columns with same name from two tables
92992
MySQL: Conditionally selecting next and previous rows
41542
Combine Two SQL queries in one statement
93731
Using Union All and Order By in MySQL
97639
Combine multiple rows into one MySQL Join
69567
How to select column in table by creating row in another table in MySQL
47033
Creating a query that uses criteria from two tables?
152144
Using mysql concat() in WHERE clause?
26537
Possible to do a MySQL foreign key to one of two possible tables?
39725
mySQL SELECT FROM table WHERE ... AND ... AND ... AND
40666
Insert into select into multiple related tables using INSERT_IDENTITY
141193
combining results of two select statements
127650
Selecting data from another table using a foreign key
91414
Mysql Update with table joins - update one table's field with sum of other table's field