Is there any way to perform a union operation in impromptu? The situation I have is that I have two large tables and I need some info from one and some info from the other.
ie. Table1 = Health Claims
Table2 = General Claims
The data in Table1 is at a more detailed level than Table2.
What I need is all health claims + all general claims that are not included in Health claims.
The only way I've found to do this is by writing two queries and using union to compile the sets, but I can't seem to get impromptu to do this. Is there a way?
Thanks,
ie. Table1 = Health Claims
Table2 = General Claims
The data in Table1 is at a more detailed level than Table2.
What I need is all health claims + all general claims that are not included in Health claims.
The only way I've found to do this is by writing two queries and using union to compile the sets, but I can't seem to get impromptu to do this. Is there a way?
Thanks,