SQL Query To Create View [closed]

CREATE VIEW EmpList
AS
SELECT  a.id_user,
        b.category_province_content,
        c.category_city_content,
        d.category_job_content
FROM    user_detail a
        INNER JOIN category_province b
            ON a.detail_province = b.id_category_province
        INNER JOIN  category_city c
            ON a.detail_city = c.id_category_city
        INNER JOIN category_job d
            ON a.detail_job = d.id_category_job

To further gain more knowledge about joins and MySQL views, kindly visit the links below:

Browse More Popular Posts

Leave a Comment