Database View is not showing results

[ServiceNowSteve]

Good Afternoon All,

I am attempting to dive into Database Views and I have created a simple view based off of a video I watched (below)

After joining my incident table and my company table I added a WHERE clause to the incident table that attempts to pull records where the "company" field on my incident table matches the "name" field on the company table.

After I "Try It" I get nothing in return, any idea why? I do know that there are records on our Incident table that match these names.

My Reference Video...picks up around 9:55

[Tim Deniston · Accepted solution]

Try using all underscores: inc_company = comp_sys_id

[ServiceNowSteve]

I'll be....it wasn't the underscores it was that I was using the sys_id on the incident not comp....you sir are amazing! Thank you!