--普通查询
SELECT T1.NAME , T2.ORDERNO
FROM TABLE_NAME1 T1 , TABLE_NAME T2
WHERE T1.ID = T2.T1_ID
AND T1.STATUS = '1';
--JOIN查询
SELECT T1.NAME , T2.ORDERNO
FROM TABLE_NAME1 T1
INNER JOIN TABLE_NAME T2
ON T1.ID = T2.T1_ID
AND T1.STATUS = '1';
注释:内连接查询-会将受关联的两表相对应的数据返回!
:JOIN 和 INNER JOIN 是一样的!
SELECT T1.NAME , T2.ORDERNO
FROM TABLE_NAME1 T1 , TABLE_NAME T2
WHERE T1.ID = T2.T1_ID
AND T1.STATUS = '1';
--JOIN查询
SELECT T1.NAME , T2.ORDERNO
FROM TABLE_NAME1 T1
INNER JOIN TABLE_NAME T2
ON T1.ID = T2.T1_ID
AND T1.STATUS = '1';
注释:内连接查询-会将受关联的两表相对应的数据返回!
:JOIN 和 INNER JOIN 是一样的!