Crosstab view

REYSAN · #1 (**permalink**) 05-10-06, 18:48

Hi
I'm trying to create a crosstab view in Pervasive.Sql
Is anyone familiar with that or done that ?
Thanks
Akila

mirtheil · #2 (**permalink**) 05-10-06, 21:41

What exactly are you trying to do? If I understand about Crosstab queries, they are just joins.

REYSAN · #3 (**permalink**) 05-11-06, 13:18

I have a table TA ,

ord Item
104460 100-813
104460 2010-0026
104460 4020-0023

I want to create a view to see this table TA as this
Ord Item1 item2 item3
104460 100-813 2010-0026 4020-0023

I know that in MSQL the TRANSFORM function can do it

Thanks

Akila

REYSAN · #4 (**permalink**) 05-11-06, 13:19

I have a table TA ,

ord Item
104460 100-813
104460 2010-0026
104460 4020-0023

I want to create a view to see this table TA as this
Ord Item1 item2 item3
104460 100-813 2010-0026 4020-0023

I know that in MSQL the TRANSFORM function can do it

Thanks

Akila

Internet Services

Web Development

Digital Marketing

Consumer Tech