Skip to Content
avatar image
Former Member

Subquery in From clause @ universe level

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 ➕

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09, 2015 at 01:37 PM

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

    Add comment
    10|10000 characters needed characters exceeded