表col-a,
表col-b,
INNER JOIN时,说明:inner可以省略。
SELECT
A_id=[col-a].aid,
B_id=[col-b].bid
FROM [col-a]
INNER JOIN [col-b]
ON [col-a].aid=[col-b].bid
LEFT JOIN时
RIGHT JOIN时
CROSS JOIN时
PHP
表col-a,
表col-b,
INNER JOIN时,说明:inner可以省略。
SELECT
A_id=[col-a].aid,
B_id=[col-b].bid
FROM [col-a]
INNER JOIN [col-b]
ON [col-a].aid=[col-b].bid
LEFT JOIN时
…
表col-a,
表col-b,
INNER JOIN时,说明:inner可以省略。
SELECT
A_id=[col-a].aid,
B_id=[col-b].bid
FROM [col-a]
INNER JOIN [col-b]
ON [col-a].aid=[col-b].bid
LEFT JOIN时
RIGHT JOIN时
CROSS JOIN时