If I have two tables that have a column called
direccion , and I want to take only one of them as I do?
Client table: ID, address, level, mail, password, name
Company table: EID, address, name
What I want to do is:
SELECT ID, direccion, nivel FROM cliente, empresa WHERE ID = 1;
The result I get is that the column
direccion is ambiguous.