php - 从mysql中的多个表中获取结果

Question

我有几个表，我需要从一个查询中获取结果。

这就是我今天的做法。

$sql="select * from structure 
a, audio b where a.id=b.id_parent and b.published=1 order by b.data desc";

这给了我一个音频列表。我需要做的是从许多表中获取响应。如您所见，我正在调用两个表结构和音频。我需要从结构、音频、矢量和照片中获取结果。任何线索我将如何做到这一点？

Answer 1

如果您在这些表中有关系，那么您可以使用连接从多个表中获取数据

select * from structure 
a inner join 
audio b on a.id=b.id_parent where b.published=1 order by b.data desc

编辑根据用户的评论

例如你可以嵌套内部连接

    SELECT DISTINCTROW 
       tblChippingSystems.Manufacturer_ID
     , tblChippingSystems.Chippingcounter
     , tblManufacturer.ManufacturerDesc
     , tblChippingSystems.Customer_ID 
  FROM ( tblChippingSystems 
INNER
  JOIN tblManufacturer 
    ON tblChippingSystems.Manufacturer_ID 
     = tblManufacturer.Manufacturer_ID )
INNER
  JOIN tblModel 
    ON tblChippingSystems.Model_ID = tblModel.Model_ID
 WHERE tblChippingSystems.Customer_ID =   k
ORDER 
    BY tblChippingSystems.Manufacturer_ID DESC

but make sure that you have proper reference between these tables and double check your resulted data