CRUD on joined tables [May 04]

:raising_hand_man: Paul asked

Hi, what is the best practice in NocoDB in order to CRUD values using the sql JOIN clause? Is there any other way to do it than to use “LinkToAnotherRecord” (based en PK and FK in a MS SQL database) and then Lookup fields on another column in NocoDB ? Thank you for your help

:person_tipping_hand: o1lab replied

Yes, that’s correct. Does ms SQL support materialised views? A user requested it for Pg

:raising_hand_man: Paul replied

Yes, materialized views exist in MS SQL, I think they are called indexed views.

Can we see them in NocoDB ?

:person_tipping_hand: o1lab replied

sorry, we do not support them. There was a discussion abt the same for PG in github issues

Autogenerated from discord

Join NocoDB’s community