Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anonymous1
Contributor III
Contributor III

Creating QVD from SQL

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?

Labels (3)
1 Solution

Accepted Solutions
atoz1158
Creator II
Creator II

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

View solution in original post

1 Reply
atoz1158
Creator II
Creator II

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