I have a table named tb_quotedetail. Inside this table i have 4 fields. F1) IDMASTER (n) F2) ORIGINID (n) F3)DESTINATIONID (n) F4)PRODUCTID(n)
origin and destination id are associated with the autoid in the table tb_city. and product id is associated with the autoid of tb_product.
So i want to do a select in tb_quotedetail where the id master is 11 and i want the product name , city origin name and city destination name. how can i do it, thanks