Join query help
Hi , I have table cars , and table my _card . I want to : SELECT * FROM cars JOIN my _cars ON cars .id = my _cars .car _id WHERE my _cars .selected = TRUE ; ' It works with query on my _cars : 'select =id ,cars ( * ) &selected =eq .true , ' but how to query cars and selecting based on my _cars ? I fount on internet the magic word [ !inner ] , and it works . it function like this . query the cars , and in parameters select =star _symbol ,my _cars !inner (star _symbol ) , then you add a new parameter named my _cars .selected = eq .true , and for major security add a new parameter my _cars .owner = eq .id _input . I would like to ask if this is safe . @Erik Beuschau i found many information you provided in query using curl , can you confirm please if this is safe ? @unicodes - This is a good reference point for PostgREST if you 're using Supabase . https://docs.postgrest.org/en/v12/references/api/resource_embedding.html#foreign-key-joins โค๏ธ1
