Access±¨´í¡°Óï·¨´íÎó ²Ù×÷·û¶ªÊ§¡± - .NET¼¼Êõ / C#

SQL code:

select A.commandKey,A.enabled,A.commandFile,A.targetControl,A.rightId,A.type,[B].[value] as commandType,A.state,[C].[value] as commandState,A.parent,A.commandText,A.commandTipText,A.icon,A.description
from t_commands as A
inner join t_parameters as B on [A].[type]=[B].[code]
inner join t_parameters as C on [A].[state]=[C].[code]
where B.id=3 and C.id=4





ÈçÉÏSQL£¬Ö´ÐеÄʱºò¾ÍÌáʾ¡°Óï·¨´íÎ󣨲Ù×÷·û¶ªÊ§£©ÔÚ¡®[A].[type]=[B].[code]  
inner join t_parameters as C on [A].[state]=[C].[code] ¡¯ÖС±µÄÌáʾ£¬È»ºóÎÒ·¢ÏÖÈç¹û°ÑºóÃæµÄjoinÓï¾äÈ¥µô²»Á¬½ÓµÄ»°¾ÍÄÜÕý³£²éѯ³öÊý¾Ý£¬ÊDz»ÊÇAccess²»Ö§³Ö¶à¸öÁ¬½Ó²éѯµÄ£¿

---

select * from (select * from table1 t1 left join table2 t2 on t1.id=t2.id) t left join table3
  t3 on t.id=t3.id 
Ö»ÓÐÓÃLEFT¡¡JOIN+RIGHT¡¡JOIN

---

select A.commandKey,A.enabled,A.commandFile,A.targetControl,A.rightId,A.type,.[value] as commandType,A.state,[C].[value] as commandState,A.parent,A.commandText,A.commandTipText,A.icon,A.description 
from (t_commands as A 
inner join t_parameters as B on [A].[type]=[B].[code] )
inner join t_parameters as C on [A].[state]=[C].[code] 
where B.id=3 and C.id=4


[b]¼ÓÉÏ£¨£©

---

ѧϰÖÐ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~¶¥Æ𣡣¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡

---

¸ßÊÖ¶¼°ïÄã»Ø´ðÁË
ÎҾ͸æËß