Select statement that combines similar rows with certain ids?
Posted
by vegatron
on Stack Overflow
See other posts from Stack Overflow
or by vegatron
Published on 2010-04-16T19:02:19Z
Indexed on
2010/04/16
23:03 UTC
Read the original article
Hit count: 263
hi
I have a warehouse_products table which defines how many products in the warehouses
so lets say I have 20 records/rows in the table, some rows may contain the same product id but in a different warehouse
I need to create select statement that give every product one row, and in this row I must have the quantity in warehouse A and warehouse B ..
so in the end I will get for example 10 rows that contain all the data
© Stack Overflow or respective owner