Hi List, I need to create a complex Select joining 2 tables.
Table Product, I have these fields: ---------------------------------------- Code (PK) Description Records: 01 Product A 02 Product B Table Price, I have these fields: ---------------------------------------- Code (PK/FK) Sequence (PK) Price Records: 01 1 10.00 01 2 12.00 01 3 14.00 01 4 15.00 02 1 20.00 02 2 22.00 03 3 23.00 04 4 24.00 I need to combine these two tables to have this layout: Product First Price Second Price Third Price Forth Price Product A 10.00 12.00 13.00 14.00 Product B 20.00 22.00 23.00 24.00 Is this possible to do if the Select instruction? If yes, is anyone can help me to build this Select? Thanks a lot. -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]