Hi!

I tried this but it seems to require all tables to contain data related to each other.

E.g, I have created a database view to display Problem data and incident data based on Incident related to problem. I also want to display the Country where these incidents were registered.

The database view looks like

View tables:

problem

        where: prb_sys_id=inc_problem_id

incident

        where: inc_problem_id=prb_sys_id

cmn_location

        where: (null)

This only displays one record, since there is only one record where the location on the incident is set and contains country data.

If i remove the cmn_location, the list will display 29 records..

I want to display all the 29 records WITH the country if applicable.

Am I doing wrong?

Hi Mathias,

If not all incidents have the location set, then set the "Left join" flag when you define the "cmn_location" within the Database View.

Telmo

This worked great! Thank you!

above solution worked. thank you

Thanks Sergiu,

I will try this option.