Attribute view blank fields during LEFT OUTER JOIN

[agentry_src]

Hi,

I have created an attribute view, for learning purposes.

I have joined three tables SFLIGHTxSBOOKxSCUSTOM, as shown in the below image, using LEFT OUTER JOIN.

The 'Raw Data' output of this view looks like below.

Why are Telephone and Email empty for multiple entries, despite having the same Customer ID?

Please help me understand what is happening here.

Thanks.

[agentry_src]

Please provide the SQL script that you are executing. It looks like you have some sort of Cartesian product with your outputs instead of single results. I would also recommend reversing the order of your join and start with the Customer rather than the Flight.

Regards, Mike

[Former Member]

Thank you Michael.

You are correct. They are from different clients. It became clearer once i added MANDT to output and join condition.

Edit: I think your response is a comment instead of an answer. So i could not mark it accepted!

[michael_eaton3]

Glad you solved it.

I didn't post it as an answer, as I was unsure whether it was an answer, or even the answer. 🙂

[michael_piesche]

michael.eaton3, you can still change a comment to an answer with the EDIT button 😉

[michael_eaton3]

Well, I never knew you could do that! Thanks for the tip.