Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

The Left Join returns all the records from the left table (Bene Data), and the matching records from the right table (Tran Summary Data). The result is 0 records from the right side, if there is no match. For example, BENE_ACC_NO is the specified column in both DEMO_BENE_DATA table and DEMO_CT_TRAN_SUMMARY_DATA table as in the following screen shots:

Bene Data Table:

Tran Summary Data Table:

The following screenshot shows a report, Beneficiary Report created by combining Bene Data and Tran Summary Data data sources using Left join operation:

  • No labels

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.