Loading

join 2 tables one to one

Violeta Popa

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!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreejesh SP13y ago
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
Shivanand Arur13y ago
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!!!