Okay, so the two queries are from same subject area and they show results when there is no table prompt. But as soon i drag a column to the table prompt in view, it shows the data which should have resulted if I applied join. Please help
Query Wrapping is what i have used to solve this issue, the prompts are working normally now.