I have two tables -- one is customer and the other proposal. I have a query (join) that matches customers with proposals based on customer_id in both tables. I display in a multi row form the proposals and want to select ONE proposal to print.
How do I select ONLY the join based on the proposal record which has the customer_id? I only want the ONE proposal and it's customer information to print.