SQL Query To Create View [closed]

by 

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:

More Related Contents:

  1. Calculate date range between two rows
  2. Calculate Average of the largest values in multiple columns
  3. Correct MySQL Syntax for WEEK
  4. remove duplicate records – mysql
  5. SQL query return data from multiple tables
  6. mysql Foreign key constraint is incorrectly formed error
  7. Unknown Column In Where Clause
  8. Calculate Age in MySQL (InnoDb)
  9. Storing JSON in database vs. having a new column for each key
  10. MySQL query String contains
  11. Best data type for storing currency values in a MySQL database
  12. Datetime equal or greater than today in MySQL
  13. MySQL dynamic-pivot
  14. Entity-Attribute-Value Table Design
  15. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  16. MySQL Workbench: How to keep the connection alive
  17. Filter by COUNT(*)?
  18. How to select rows that have current day’s timestamp?
  19. MySQL concatenation operator
  20. SQL Group By with an Order By
  21. How create json format with group-concat mysql?
  22. MySQL LIKE query with underscore
  23. MySql – Way to update portion of a string?
  24. Using reserved words in column names
  25. MySQL INNER JOIN select only one row from second table
  26. Storing IPv6 Addresses in MySQL
  27. What is the difference between SQL and MySQL? [closed]
  28. how to use a like with a join in sql?
  29. Get total hours worked in a day mysql
  30. ORDER BY alphabet first then follow by number

Leave a Comment