Creating QVD from SQL

[anonymous1]

hey, 

im trying to create a QVD using SQL  but keep getting an error : ORA-00923: FROM keyword not found where expected.  my code is as follows

TABLE:
SQL
SELECT
"qr.ROWID" as [row_id],
"qr.organization_id",
"qr.collection_id",
"qr.occurrence",
"qr.qa_last_update_date" as [last_update_date],
"qr.qa_last_updated_by" as [last_updated_by_id],
"qr.qa_creation_date" as [creation_date]
FROM
"apps.qa_results" qr,
"apps.qa_plans" qp
WHERE
qp.plan_id = qr.plan_id
;

store TABLE into D:\TABLE.qvd

have i got the syntax wrong somewhere?

[atoz1158 · Accepted solution]

Hi

Can I suggest you try the following

TABLE:
SQL
SELECT
"qr.ROWID" as [row_id],
"qr.organization_id",
"qr.collection_id",
"qr.occurrence",
"qr.qa_last_update_date" as [last_update_date],
"qr.qa_last_updated_by" as [last_updated_by_id],
"qr.qa_creation_date" as [creation_date]
FROM
"apps.qa_results" qr INNER JOIN
"apps.qa_plans" qp ON qp.plan_id = qr.plan_id
;

store TABLE into D:\TABLE.qvd;

Regards

Adrian