Y2S1-Database_Design/SQL/views/Production Entries.sql

4 lines
338 B
MySQL
Raw Permalink Normal View History

2020-06-07 21:29:59 +00:00
SELECT dbo.MediaEntry.EntryID, dbo.Users.UserID, dbo.Users.UserName, dbo.Production.ProductionName
FROM dbo.Users INNER JOIN
dbo.MediaEntry ON dbo.Users.UserID = dbo.MediaEntry.UserID INNER JOIN
dbo.Production ON dbo.MediaEntry.ProductionID = dbo.Production.ProductionID