Help converting a mysql query

[RedVox]

I'm having a hard time figuring out how to replicate a mysql query in an appsheet formula.  In mysql, this is the query:

SELECT * FROM boats WHERE boat_id NOT IN (SELECT boat_id FROM slips);

I've tried a dozen things but none seem to be on track.  Fingers crossed that the right formula can save me from creating a mysql view and related UX view, etc.  

[Suvrutt_Gurjar]

Maybe this?

SELECT(boats[boat_id], NOT(IN([boat_id], slips[boat_id])))

[RedVox]

When I try the suggestion, I get LINKTOFILTEREDVIEW has invalid inputs in response.  

[Suvrutt_Gurjar]

Please share the LINKTOFILTEREDVIEW() expression and your requirement details for any possible suggestion.

[RedVox]

Thanks but I found a workaround using a lookup instead.

[Suvrutt_Gurjar]

Great. Thank you for the uodate.