Edit Question

Title Body

I have a table that uses 3 foreign keys into other tables. When I perform a left join, I get duplicate columns. MySQL says that the USING syntax will reduce the duplicate columns, but there aren't examples for multiple keys. Given: mysql> describe recipes; +------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+-------+ | ID_Recipe | int(11) | NO | PRI | NULL | | | Recipe_Title | char(64) | NO | | NULL | | | Difficulty | int(10) unsigned | NO | | NULL | | | Elegance | int(10) unsigned | NO | | NULL | | | Quality | int(10) unsigned | NO | | NULL | | | Kitchen_Hours | int(10) unsigned | NO | | NULL | | | Kitchen_Minutes | int(10) unsigned | NO | | NULL | | | Total_Hours | int(10) unsigned | NO | | NULL | | | Total_Minutes | int(10) unsigned | NO | | NULL | | | Serving_Quantity | int(10) unsigned | NO | | NULL | | | Description | varchar(128) | NO | | NULL | | | ID_Prep_Text | int(11) | YES | | NULL | | | ID_Picture | int(11) | YES | | NULL | | | Category | int(10) unsigned | NO | | NULL | | | ID_Reference | int(11) | YES | | NULL | | +------------------+------------------+------+-----+---------+-------+ 15 rows in set (0.06 sec) mysql> describe recipe_prep_texts; +------------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------+------+-----+---------+-------+ | ID_Prep_Text | int(11) | NO | PRI | NULL | | | Preparati

Tags (comma-separated) Cancel