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.