I need to select the 3 particular field in 3 tables .i given the details below

unit price is a field in  table( table name veg detail) then Required quantity is in table(table name order detail ) then PON is in table( table name PON Detail ),(in table PON detail ,Order Detail the same field is  Customer name)


in table order detail,veg detail same field is item name ,and category name
date is same in pondetails and order details. i need the following details in
final table  contains field is itemname req qty,unitprice