28 replies

How to Chain multiple selects

I am new to ORMS and SQL so please bear with me. I have the attached schema for the chat component of the app that I am building. I am a bit lost how I would chain this sequence of select statements

select * from chat_room_participants where user_uid='d0fc7e46-a8a5-4fd4-8ba7-af485013e6fa'
select * from chat_rooms where id=1
select * from chat_messages where chat_room_id=1

select * from chat_room_participants where user_uid='d0fc7e46-a8a5-4fd4-8ba7-af485013e6fa'
select * from chat_rooms where id=1
select * from chat_messages where chat_room_id=1

help much appreciated

How to Chain multiple selects

Similar Threads