Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make a outer join between two Tabulars

Status
Not open for further replies.

lincon

MIS
Dec 24, 2002
50
CN
Query has a tabular Model including two tabular Model(tabular1 and tabular2),I want to make a outer join between tabular1 and tabular2.I don't know how to do.Someone can tell me about it,very appreciates!
 
Just try this..

In the filter of the main tabular model, you can specify the outer join condition directly.. something like

tabularmodel1.productid = tabularmodel2.productid(+)
 
CRN - RS wouldn't allow you to write
tabularmodel1.productid = tabularmodel2.productid(+) in filter condition

2 solution to this:

1. Create 2 Model Query subject and Define Relationship in Framework manager itself or
2. Write the filter this way

tabularmodel1.productid = tabularmodel2.productid or
tabularmodel1.productid is missing
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top