Oct-16-2018, 04:08 PM
There are 2 related tables in db.
One order_ID(table1) is mapped with multiple values prod, quantity and rate. One to Many relationship. I want to display all these values in one common table.
table 1:
order_ID date buyer ship_chr total_price
001 01/01 abc 15 240
002 05/01 xyz 10 235
table 2:
order_ID product quantity rate
001 pen 50 2
001 paper 25 1
001 pin 50 2
002 paper 25 1
002 pen 100 2
I want to display all values in one row, so all multiple values should be displayed in one cell only. So, how to display multiple values of prod, quantity and rate corresponding to one orderID?
OrderID Date Buyer Prod Quantity Rate Shipping Total
001 01/01 abc pen 50 2 15 240
paper 25 1
pin 50 2
002 05/01 xyz paper 25 1 10 235
pen 100 2
One order_ID(table1) is mapped with multiple values prod, quantity and rate. One to Many relationship. I want to display all these values in one common table.
table 1:
order_ID date buyer ship_chr total_price
001 01/01 abc 15 240
002 05/01 xyz 10 235
table 2:
order_ID product quantity rate
001 pen 50 2
001 paper 25 1
001 pin 50 2
002 paper 25 1
002 pen 100 2
I want to display all values in one row, so all multiple values should be displayed in one cell only. So, how to display multiple values of prod, quantity and rate corresponding to one orderID?
OrderID Date Buyer Prod Quantity Rate Shipping Total
001 01/01 abc pen 50 2 15 240
paper 25 1
pin 50 2
002 05/01 xyz paper 25 1 10 235
pen 100 2