Skip to content
Advertisement

JOIN on two tables

I have two tables:

user:

and credential:

I want to perform a query to get the following result (one row for every user):

Right now I am executing this query:

This results in:

I want a single row for a user. How can I achieve this?

Advertisement

Answer

You can use two joins:

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement