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
Yes, that’s correct. Does ms SQL support materialised views? A user requested it for Pg
Yes, materialized views exist in MS SQL, I think they are called indexed views.
Can we see them in NocoDB ?
sorry, we do not support them. There was a discussion abt the same for PG in github issues