cancel
Showing results for 
Search instead for 
Did you mean: 

Subquery in From clause @ universe level

Former Member
0 Kudos

hello Experts,

i want to implement subquery in From clause @ the universe level without creating derived table

Query:

SELECT DISTINCT

  'All_Discrepancies' Report,

  a.STUDY,

  b.DOC_INCREC_FLAG INCREC_FLAG,

  a.SITE,

  a.COUNTRY

From

(

Select

  C.STUDY,

  A.COMMENT_TEXT

from  --(ALL_DISCREPANCY)

rxc.discrepancy_management a,

rxa_des.clinical_studies c,

rxc.procedures p,

WHERE a.clinical_study_id = c.clinical_study_id

and a.clinical_study_id = r.clinical_study_id

and a.clinical_study_id = p.clinical_study_id

)a

Where

a.DOCUMENT_NUMBER = b.DOCUMENT_NUMBER

Accepted Solutions (0)

Answers (1)

Answers (1)

arijit_das
Active Contributor
0 Kudos

Why don't you want to create a derived table ? Is it possible to create a view in the database ?