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

Answer 1

www.tutorialspoint.com/plsql/plsql_arrays.htm

Answer 2

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

Answer 3

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