I am attempting to create a report using the Query editor in the Generate Excel Report section. I have a few years of experince writting MS SQL using oother tools. IS the SQL in Quality Center a subset of commands?. I cannot use the "CREATE VIEW" to build a temp table. Everything else works in the query.
CREATE VIEW MyDefectsView
AS
SELECT L.AL_DESCRIPTION,
B.BG_BUG_ID,
B.BG_DESCRIPTION,
B.BG_SEVERITY,
B.BG_SATUS
FROM BUG AS B
JOIN All_List AS L
ON B.BG_SUBJECT = L.AL_ITEM_ID
ORDER BY B.BG_BUG_ID;