0

Hey.. I want to select 2 columns from table A and 1 column from table 2. What syntax do i use please?

7th May 2018, 9:53 AM
Jims
3 odpowiedzi
7th May 2018, 10:18 AM
D_Stark
D_Stark - avatar
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
12th May 2018, 9:27 AM
SQrL
SQrL - avatar
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
15th May 2018, 1:50 AM
Luis Gonzalez
Luis Gonzalez - avatar