I looked into it…all columns data types are same…m having values in columns like
20345
20456
so on up to 30 crores.
data type of this column in all tables as character length 16.
I have master table as some x…this x table joins with 10 other tables.
When I am including the table a with x then it pulling the data.when I am including b table along with A table to x then its showing this error.
and apart from that I have large volume of data in the tables approximately 4o crore records.
when i am testing x and a table itz fetching data.
when i am testing x with a and b tables then itz displaying error.
and when m testing x and b table itz fetching data.
if m adding testing with more than 2 tables itz displaying error.