database view question

[drslry2]

Hi gurus,

I'm attempting to create my first database view and between a custom table that looks like this...

and the 'Business Application' class...using the following left join...

...however it returns no records.

Any idea what to join on in this case?

thanks in advance.

Rob

[maroon_byte]

Confirm the actual field name of the 'Configuration Item' field. It could be 'ci'. So your join would be bae_sys_id = bus_ci

Regards,

Sharad

[AndersBGS]

Please share a snip of your database configuration, hence it will be much easier to help you.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[drslry2]

Hi Anders,

thanks for the reply, I'm not sure how to go about sharing a snip of the database configuration...do you want to see the table structure for a specific table?

thanks again

[AndersBGS]

Hi @drslry2 ,

Snip similar to below:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders