join 2 tables one to one

Question

Hi there :)

I need to join 2 one to one tables. How can i do that? Here's sth i've wrote, but it doesn't work.

SELECT * FROM utilizator JOIN client ON utilizator.id_client=client.id_client ON utilizator.id_utilizator=client.id_utilizator WHERE id_utilizator=username ...etc

Thanks!

Shivanand Arur · Answer

Try this :- SELECT * FROM utilizator INNER JOIN client ON utilizator.id_client = client.id_client AND utilizator.id_utilizator = client.id_utilizator WHERE id_utilizator=username ...etc Please mark the answer as accepted if it helped!!!

Sreejesh SP · Answer

Dear popa SELECT * FROM utilizator inner JOIN client ON utilizator.id_client=client.id_client and utilizator.id_utilizator=client.id_utilizator WHERE id_utilizator=username ...etc Try this code Thanks Sreejesh S P