Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Database View - Need help in creating DB View

VinuS
Tera Contributor

‎12-12-2023 04:37 AM - edited ‎12-12-2023 04:38 AM

Hi Team,

I have requirement to create a Database View for two custom tables say A and B. Both tables having a reference field  named as "Account" to customer_account table. There is no direct relationship  between A and B but we have account field referring to customer_account table. Hope this makes sense.

I have two queries on this.

1. How to create a Database View having where clause as a.account = b.account. 

2. I want all the fields of table A and Table B without any condition.

Please pour your suggestion on this.

 

Thanks in advance,

Vinu

0 Helpfuls
  • 430 Views
2 REPLIES 2

Ankur Bawiskar
Tera Patron

‎12-12-2023 07:25 AM

@VinuS 

your where clause is correct

did it not work?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

VinuS
Tera Contributor
In response to Ankur Bawiskar

‎12-12-2023 08:16 AM

Hi Ankur,

 

Yes, I dnt get any records in the DB View. I had few records in both the tables A and B with matching field value "account".

Thanks,

Vinu

0 Helpfuls