Hi All,
I am writing some reports based out of an Informix database. The catalogs were built for us when our original system was setup. Basically, I need to connect several different tables and it's using a propietary way of joining them. I have gone into my profile settings and looked at the SQL statement and it's joining the tables not how I want. I want to be able to modify that statement. Is there anyway I can do that? I've been told you can do this, but no one knows how. Any ideas?
I am writing some reports based out of an Informix database. The catalogs were built for us when our original system was setup. Basically, I need to connect several different tables and it's using a propietary way of joining them. I have gone into my profile settings and looked at the SQL statement and it's joining the tables not how I want. I want to be able to modify that statement. Is there anyway I can do that? I've been told you can do this, but no one knows how. Any ideas?