'How to select multiple Columns in SQL with inner join

as you can see in my picture i have got an eer-model with 6 tables. enter image description here Now I want from the table "catalog" the "ItemID", from "Users" the "UserID" and from "Roles" the "RoleID" selected in one Table.

enter image description here

Here is like how my result should look like, just with content

enter image description here

mysqlsqlmultiple-columnsentity-relationship


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions