将另一个表中的一行连接到另一个表格php mysql中

Question

我使用以下查询从数据库检索项目列表

    $statement = $conn->prepare('SELECT * FROM diamondsList WHERE price >= :minPrice AND price <= :maxPrice AND carat >= :minCarat AND carat <= :maxCarat AND cut IN(' . $cut . ') AND clarity IN ('.$clarity.') AND color IN ('. $color.') AND diamondsType IN (' . $type.') ');

diamondsList包含dealerId

我想添加diamondsList i diamondsList->dealer的经销商表.搜索后，我发现连接是使用的，但不确定如何使用它从diamondList->dealerId获取经销商行。

Answer 1

就像..。

SELECT diamondsList.*, 
dealer.name
FROM diamondsList
JOIN dealer
on diamondsList.dealerid = dealer.dealerid
WHERE .....