Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Rows into columns

0 views

Skip to first unread message

unread,

Jul 13, 2007, 2:37:26 AM7/13/07

Hi..

I have two table and want to create a row with data from these tables
-

Table1
orderid, name, address...tec

Table2

orderid, productid, productdescription..etc

I want a row as follows with header -

orderid, name, product1, product1desc, product2, product2desc...tec.
12323 Brain ww dfsdfsd bbbb ewrrewrwer

the number of products in a order may differ for each order.

How to achieve this?

Thanks Danie Felix

unread,

Jul 13, 2007, 11:31:34 AM7/13/07

--
Anith

0 new messages