厦门建设厅查询网站首页,做原创音乐的网站,asp.net开发网站好不好,织梦模板网站好优化吗我有一个表,使用3个外键到其他表.当我执行左连接时,我会收到重复的列.MySQL表示,USING语法将减少重复的列,但没有多个键的示例.鉴于#xff1a;mysql describe recipes;---------------------------------------------------------------| Field | Type | Null | Key | De…我有一个表,使用3个外键到其他表.当我执行左连接时,我会收到重复的列.MySQL表示,USING语法将减少重复的列,但没有多个键的示例.鉴于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 | || Preparation_Text | varchar(2048) | NO | | NULL | |------------------------------------------------------------2 rows in set (0.02 sec)mysql describe recipe_prep_texts;------------------------------------------------------------| Field | Type | Null | Key | Default | Extra |------------------------------------------------------------| ID_Prep_Text | int(11) | NO | PRI | NULL | || Preparation_Text | varchar(2048) | NO | | NULL | |------------------------------------------------------------2 rows in set (0.02 sec)mysql describe mp_references;--------------------------------------------------| Field | Type | Null | Key | Default | Extra |--------------------------------------------------| ID_Reference | int(11) | NO | PRI | NULL | || ID_Title | int(11) | YES | | NULL | || ID_Category | int(11) | YES | | NULL | |--------------------------------------------------3 rows in set (0.00 sec)我的查询语句SELECT *FROM RecipesLEFT JOIN (Recipe_Prep_Texts, Recipe_Pictures, mp_References)ON (Recipe_Prep_Texts.ID_Prep_Text Recipes.ID_Prep_Text ANDRecipe_Pictures.ID_Picture Recipes.ID_Picture ANDmp_References.ID_Reference Recipes.ID_Reference);我的目标是从连接中获取一行不含重复列的所有列.我使用MySQL C连接器发送SQL语句并检索结果集.我相信C连接器有重复列名的问题.那么我应该使用什么是SQL语句语法
