I have two tables

product

and

shop

I have created a realtime to product so when a new product is added it shows immediately in my app. The

product

table has a foreign relation to shop with column

shop_id

how can I get the shop details as will with my subscrition as it only contains shop_id currently

I don't think you can do relationships with realtime, so you will have to run another query to get the data from the related

shop

table

That's what I thought, thanks for the response.