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