Cita: SELECT a.*, b.* FROM tabla1 a INNER JOIN tabla2 b ON a.campoid = b.campoforaneo [WHERE condiciones]
SELECT
a.columna1, a.columna2, b.columna1, b.columna2
FROM tabla1 a
INNER JOIN tabla2 b ON a.campoid = b.campoforaneo
WHERE [WHERE condiciones]
SELECT
a.columna1, a.columna2, b.columna1, b.columna2
FROM tabla1 a
INNER JOIN tabla2 b ON a.campoid = b.campoid
WHERE [WHERE condiciones]
SELECT
a.columna1, a.columna2, b.columna1, b.columna2
FROM tabla1 a
LEFT OUTER JOIN tabla2 b ON a.campoid = b.campoforaneo
WHERE [WHERE condiciones]
SELECT
a.columna1, a.columna2, b.columna1, b.columna2
FROM tabla1 a
RIGHT OUTER JOIN tabla2 b ON a.campoforaneo = b.campoid
WHERE [WHERE condiciones]