Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to list only data from Tb1 which are not in Tb2

Hello,

I want to list data from field "table1.nr" in query which dont exist in "table2.nr field".

How can i please write a formula that can help me here correctly compare the data from table1 to those of table2 before listing it .

Many thanks for helping

Kind regards

Arnaud

replied

Hi Arnaud,

A formula won't work if you are using a equal join in your DB link. Try changing your linking in the Database connection Wizard. You could also reversion the link would be another option.

Thank you

Don

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question