How to select sql query for two table with multiple values in php <p>I have two tables in my SQL Server database. The first is <code>bidder_interest_name</code> and second is <code>tender_type_subcat</code> . There have multiple value column <code>bidder_interest_subcategory</code> in <code>bidder_interest_name</code> and <code>tender_type_subcategory</code> in <code>tender_type_subcat</code> tables.</p> <p>Now I want to select the multiple values from both the tables for a particular subcategory and need to both table minimum matching value.</p> <p>This is what I'm doing</p> <p>What I have tried:</p> <pre><code>SELECT bi.bidder_interest_subcategory,tt.tender_type_subcategory FROM bidder_interest_list as bi,new_tender_two as tt WHERE bi.bidder_id=$bidder_id </code></pre>