Select two columns with same name from two different tables

You alias the tables, and get the field you want from each table:

SELECT a.dato, b.dato FROM tabla1 a, tabla2 b

If you want only the value of the field of table1:

SELECT a.dato FROM tabla1 a, tabla2 b

or if you want only the value of the field of table2:

SELECT b.dato FROM tabla1 a, tabla2 b

Based on your question, if you wanted to get the address field only from the customer table it would be:

SELECT ID, cliente.direccion, nivel FROM cliente, empresa WHERE ID = 1;

or otherwise:

SELECT ID, a.direccion, nivel FROM cliente a, empresa b WHERE ID = 1;

I imagine that you mean to make a select of both tables but only show the field direccionof one of them. Use aliases and set which field you want to show

SELECT t1.direccion, t1.campo2, t2.campo3
FROM tabla1 t1, tabla2 t2
WHERE t1.id = t2.tabla1_id

This is an example of how you can do it.

I think what you want to do is the following,

SELECT ID, 
a.direccion AS cliente_direccion,
b.direccion AS empresa_direccion,
a.nombre AS cliente_nombre,
b.nombre AS empresa_nombre
FROM cliente AS a, empresa AS b 
WHERE ID = 1;

The way to do it is:

SELECT cliente.ID AS ID_Cliente, cliente.direccion AS Direccion_del_Cliente, empresa.direccion Direccion_de_la_Empresa, cliente.nivel AS Cliente_Nivel FROM cliente, empresa WHERE ID = 1 AND empresa.EID = 2 

Aliases ARE NOT necessary, but they allow you to identify in the columns of the query which table each one belongs to, otherwise, it would show you: "Address" and you would not know which table it refers to.

I made the query on the Customer ID "AND" the EID of the company 2. If you do not put any EID of the company, it will throw you (in this way) ALL the addresses of the "company" table while it will always show you the same record of the "customer" table (the number 1).