I think I am not clear, I want to go deeper and explain you guys...
In first table I have a field refference Id
I want to join two tables on Refference Id....
I am doing 1st table Inner join 2nd table....but here I want to load data from 2nd table which same refference Id in 1st table...In Qlikview when I do inner join its loading 1st table and also fetching all records from 2nd table while script execution.....
Is there a way other than inner join to join two tables with my given conditions......
You can use the where exists condition on the second table to read only that data which is existing in the first table (assuming your first table loads 1 year of data and has a key field that is used to join both the tables).
The syntax should look something like this:
inner join (Table 1)
from Table 2
where exists (ID,ID);
Hope that helps.