Is it possible to have Union in View?
Suppose I want to union my invoice and receipt table into one single table transaction view, is it possible?
If yes, could you please give me some example how to do that?
In fact, all I want is to have it in a single query, so that I can use the predicate search for pagination.
Hi @rivantsov ,
Is it possible to have Union in View? Suppose I want to union my invoice and receipt table into one single table transaction view, is it possible? If yes, could you please give me some example how to do that?
In fact, all I want is to have it in a single query, so that I can use the predicate search for pagination.
Thanks!