General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a customer table that has a row for each of the last 15 items the
customer has ordered. Now I need to build a table that has one row per
customer with each of the 15 items on that one row. So I need to take 15 rows
of customer_no, Item_no and create a table of customer_no, item_no1,
item_no2, item_no3, etc.
Any ideas?
Thanks
Brenda
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only