When i run the folowing query in the sql assistant.The query didnt fetch any rows.
select * from tablename1 left outer join tablename2 on join condition;
But when i rewrote the same query
select * from database_name.tablename 1 left outer join database_name.tablename2 on join conditon;
I got more than 25000 rows;
I even tried SET SESSION DATABASE . but i didnt get the result. i am using teradata 12.0 What is the problem here?
There's an option to disconnect after every query, maybe this is set?
tools -> options -> query -> disconnect from database when no query is running.