I have an SQL Query on inner join, as r.fcs_nr = jcs.fcs_nr(+), the result of this query says that if ineer join do not have anything common, it will take the prior table. I want to know how we can impliment similar condition in qlik scripting. i.e. if the result of innner join is nul then it will take prior table.
You could apply the inner join and checking then within an if-loop the noofrows('YourTable') to do anything different or just to continue with your script.
