I have table uib
column: uid
, bid
, iid
, access
I have another table uit
column: uid
, tid
, access
, iid
need to set bid = 2
now, I want to get uid
, iid
rows from table uit
and add concate bid
in query result. and add to uib
in bulk.
how to achieve it by prisma query.