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
  • 175 Views
2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

‎12-12-2023 07:25 AM

@VinuS 

your where clause is correct

did it not work?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x 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