I am facing a scenario wherein i have a basic notification on a table and i have to use a join for another table in the same basic notification.
So i am doing select t1.X,t2.Y,t2.Z where t1.X=t2.X.
However when i enable this notification, the data is not picked up,nor are the rows deleted.
My question is are joins permissible in Basic notifications.
If yes, will the data be deleted from the buffer table on which the basic notification is configured?