Hi there,
I have two tables: messages and users_messages where this last one has a reference to messages by its id.
I'm a java developer and normally I would do
select * from messages m left join users_messages um on um.message_id = m.id where um.id = null
My goal is to select all the messages that hasn't a reference to users_messages.
I already tried to do something like this below
Unfortunately It didn't work.
How can I do this in Xano?