mysql

this is what i need

tbl_what_i_need
trans_id +
1	|
	-> detail_id + item_id + item_name + item_prize
	   1	       1         drinks      2
	   1           2         foods       3
2       |
        -> detail_id + item_id + item_name + item_prize
	   2           2         foods       3

here is my table

tbl_items
--------------------------------
item_id + item_name + item_prize
1	+ drinks    + 2
2	+ foods	    + 3
--------------------------------

tbl_details
--------------------------------
detail_id + item_id
1	  + 1
1	  + 2
2	  + 2

tbl_transaction
--------------------------------
trans_id + detail_id +
1	 + 1
1        + 1
2	 + 2
--------------------------------


thanks