We upgraded from asa6 to asa9. After an unload in 6 and a reload in 9 we had our new database. Everything seems to be fine. But when we run the next sql-statement we don't get the rights results back anymore. Does anyone have a clue?
select A.table_name as ATableName,role
from SYSTABLE as A left outer join SYSFOREIGNKEY on A.table_id = primary_table_id
left outer join SYSTABLE as B on B.table_id = foreign_table_id
where B.table_name = 'Employee'
order by 2 asc