Hello Mr. Sarwar!
I'm not certain about first and last names in foreign countries, so my
apologies if it's your first name.
Am Montag, dem 15.04.2024 um 12:25 +0000 schrieb M Sarwar:
>
> Hello Andreas,
> Using a function, I am generating CROSSTAB SQL and the number of
> columns will vary for each execution. With that, it is extremely
> difficult to use view on this task.
I'm still not sure whether I understand your question. You look for a
way to produce statements like
SELECT test1p1.data, test1p2.data, test1p3.data,
f(test1p1.data), f(test1p2.data), f(test1p3.data)
FROM test1p1, test1p2, test1p3;
programmatically? ("f()" is a user-defined function deriving the left
values on the sample-picture to the right values.)
In case using multiple tables is new to you, have a look at the "JOIN"-
statement.
Regards,
Andreas Wagner