Breaking News: Grepper is joining You.com. Read the official announcement!

mysql create view joint tables

Ashar Dweedar answered on February 14, 2023 Popularity 2/10 Helpfulness 1/10

answer mysql create view joint tables

mysql create view joint tables

Comment

CREATE VIEW GiftsList
AS
SELECT  b.name user_from,
        c.name user_to,
        d.name gift_name,
        d.price gift_price
FROM    gift a
        INNER JOIN users b
            ON a.user_from = b.id
        INNER JOIN users c
            ON a.user_from = c.id
        INNER JOIN items d
            ON a.item = d.id

Popularity 2/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: create-view mysql sql

Link to this answer
Share Copy Link