replace tables with one sql command

Hi folks

I have a report, that uses two tables.
I need to replace both tables with one new sql command that returns at least the same columns (same names).
I can replace a table with a new table.
I can replace a sql command with a table.

I tried to replace one table with an sql command, after hit update, i got the dialog to type in my query. After that nothing hapens. I got returned to the replace dialog where i have choosen with table i wanna replace with an other one.
So maybe I’m to stupid to replace one table… but two? :slight_smile:

has someone any idea?


spali (BOB member since 2009-05-18)