I need to create a database view to join 2 tables

Ken61
Giga Guru

‎01-03-2024 04:12 AM

Hello All,

I am having trouble creating database view to join "sys_user_group" with "sys_group_has_role" table.

Please assist on steps to get the database view created.

Thank You

0 Helpfuls
  • 196 Views
3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

‎01-03-2024 04:14 AM

Hi @Ken61 

 

What issue you are facing? and what you want to from this database view.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

Anil Lande
Kilo Patron

‎01-03-2024 04:15 AM

What is expected output?

for what purpose you are creating database view?

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande
0 Helpfuls

AndersBGS
Tera Patron
Tera Patron

‎01-03-2024 04:59 AM

Hi @Ken61 ,

 

What is the business requirement? What is it that you would like to obtain from this?

 

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

 

best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

0 Helpfuls