<Is their a better way to populate ignored column ...

# stackoverflow

[user]

Is their a better way to populate ignored column from another table using room
I have two related tables item and purchase. The purchase class contains an ignored column itemName which I want to fill with itemName from item

Although I have a method but I am concerned if there is a better way
to achieve it because my way has to do with reading all items from the database then comparing purchase.itemOwnerID to item.itemID


Here is my populating code along with others

LaunchedEffect(key1 = true) {
sharedViewModel.requestAllPurchases()...