Can I exclude some rows with join?
I have a query from which I want to exclude records based on certain condition. for example, I have a list of events and I want to exclude those events which are already followed by the user (I have follows as separate table with reference to user and to event).
So my idea was to join the follows table with condition that following user must be current user, and then in custom query create a condition that event_id =/ follows.event_id.
But it does not seems to work.[image.png]
Other
7 replies