Sql语句中的inner join on,array都是什么意思 sql中inner join on 和一般的多表查询有什么区...
SQL\u8bed\u53e5\u4e2d\u7684\u201cINNER JOIN\u201d\u662f\u4ec0\u4e48\u610f\u601d\u554a\uff1f\u5185\u8054\u63a5\u3002
JOIN \u5206\u4e3a\u5185\u8fde\u63a5\uff0c\u5916\u8fde\u63a5\uff08\u5de6\u5916\u8fde\u63a5\uff0c\u53f3\u5916\u8fde\u63a5\uff0c\u5168\u5916\u8fde\u63a5\uff09
\u5185\u8fde\u63a5\uff1a SELECT A.* FROM A INNER JOIN B ON A.ID=B.ID
\u5de6\u5916\u8fde\u63a5\uff1a SELECT A.* FROM A LEFT JOIN B ON A.ID = B.ID
\u53f3\u5916\u8fde\u63a5\uff1a SELECT A.* FROM A RIGHT JOIN B ON A.ID = B.ID
\u5168\u5916\u8fde\u63a5\uff1a SELECT A.*, B.* FROM A FULL OUTER JOIN B ON A.ID = B.ID
\u6ca1\u4ec0\u4e48\u533a\u522b\uff0c\u5728\u6267\u884c\u65b9\u5f0f\u548c\u6548\u7387\u4e0a\u90fd\u662f\u4e00\u6837\u7684
\u53ea\u662f\u4e66\u5199\u7684\u65b9\u5f0f\u4e0d\u540c
\u57fa\u672c\u4e0a\u8fd9\u4e2ainner join \u662f\u4e3a\u4e86\u533a\u522b left join ,right join\u7b49\u7684\u4e00\u4e2a\u5199\u6cd5
\u800c\u53e6\u5916\u90a3\u79cd\u4e0d\u662fjoin\u7684\u5199\u6cd5\uff0c\u53ea\u80fd\u7b49\u540c\u4e8einner join
例如表a,表b,2个表有关联字段
一般是这样写
select *
from a inner join b on a.id=b.id
2个表关联查询相关数据的意思
array是数组的意思,在sql里面是没有数组的,
估计你说的是放在from 后面的一个表名
扩展阅读:vb6 sql inner jion ... sql中inner join ... 左连接 ... sql命令 inner join ... sql inner join where ... inner join 多个on ... sql inner join on 多条件 ... inner join on用法 ... sql语句inner join详解 ...