为每个父行创建具有嵌套行的表

Table 1

orderid   customerName  totalCost
----------------------------------
1         Jonh           £200.00
2         Ringo          £50

Table 2 

orderlineid orderid productName productPrice  Quantity 
-------------------------------------------------------
1              1      Product1    £150            1
2              1      Product2    £50             1 
3              2      Product3    £50             1

Table 3

orderid    customerName     totalCost
---------------------------------------
 1          John            £200
---------------------------------------
+ 1        1       Product1 £150   1    
+ 2        1       Product2 £50    1
---------------------------------------
2           Ringo           £50
---------------------------------------
+ 3        2       Product3 £50 
Table 1

orderid   customerName  totalCost
----