0
Hey.. I want to select 2 columns from table A and 1 column from table 2. What syntax do i use please?
3 ответов
0
Select A.1, A.2, B.3
From A inner join B
On A.id = B.id
1 2 and 3 represent column names not actual syntax
If you want to filter more you can use a where clause
Inner join may not be right for you
If you post details about the table columns I can help some more
0
Sin usar INNER JOIN
SELECT ARTICULOS.Nombre, Precio, FABRICANTES.Nombre
FROM ARTICULOS, FABRICANTES
WHERE ARTICULOS.Fabricante = FABRICANTES.Codigo
Usando INNER JOIN
SELECT ARTICULOS.Nombre, Precio, FABRICANTES.Nombre
FROM ARTICULOS INNER JOIN FABRICANTES
ON ARTICULOS.Fabricante = FABRICANTES.Codigo