Versions Compared

Old Version 6

changes.mady.by.user Former user

Saved on

compared with

New Version 7

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article explains how to show all table rows when using a query in within a query by using SQL for Confluence app.

Instructions

  1.  It  Following query is an example that uses a join query, one query depends in data provided by the other and provides data to an outer query. Write the below query code in a SQL Query macro and select Output format as Wiki.

    Code Block
    themeMidnight
    select
tpa.MRN, 
'{sql-query:dataSource=Test} 
SELECT
tp.WPR_ID ,tpp.TEST_PATIENT_ID
FROM TEST_PROXY tp
JOIN TEST_PATIENT_PROXY tpp ON tpp.TEST_PROXY_USERNAME = tp.USERNAME
WHERE tpp.TEST_PATIENT_ID =' + CONVERT(VARCHAR(12),tpa.ID) + 
' {sql-query}' 
as "Proxy"
from TEST_PATIENT tpa


  2. The output of the above query is as shown below: