How to create a database view with a join on the enterprise_taxonomy_node table

[vijani]

I have created the following database view by joining three tables, but the data is not populating as expected. Could anyone please help me resolve this issue?
enterprise_taxonomy_node 
sn_templated_snip_note_template 
sn_hr_core_fulfillment_instructions 

when i am clicking try it, it's showing empty like below 

[Runjay Patel]

Hi @vijani ,

try like below.

Primary Table	Join Table	Join Condition
enterprise_taxonomy_node (etn)	sn_templated_snip_note_template (snip)	etn.sys_id = snip.taxonomy_node
sn_templated_snip_note_template (snip)	sn_hr_core_fulfillment_instructions (hrfi)	snip.sys_id = hrfi.note_template

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[vijani]

Hi @Runjay Patel 

Sorry, i tried it but it is not working 

[Runjay Patel]

Hi @vijani ,

check below

is taxonomy_node filed is reference pointing to enterprise_taxonomy_node table?

is note_template filed is reference pointing to sn_templated_snip_note_template table?