Advertisement
Albinutte

cs dbms task 10

Nov 26th, 2014
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE VIEW BugCompProj
  2. AS
  3. SELECT B.num bug_num, B.title bug_title, B.submission_date submission_date, B.owner_id owner_id, B.status_id status_id,
  4.        C.title component_title,
  5.        P.id project_id
  6.  FROM Bug B
  7.     JOIN BugComponent BC ON BC.bug_num = B.num
  8.     JOIN Component C ON C.id = BC.component_id
  9.     JOIN Project P ON P.id = C.project_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement