从mysql中的许多表中获取结果

发布于 2024-12-10 00:11:01 字数 270 浏览 0 评论 0原文

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

这就是我今天的做法。

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

这给了我一个音频列表。我需要做的是从许多表中获取响应。正如你所看到的，我正在调用两个表结构和音频。我需要从结构、音频、矢量和照片中获得结果。有什么线索我会怎么做吗？

原文

I have a few tables wich I need to get results from into one query.

This is how I make it today.

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

This gives me a list of audio.
What I need to do is get responses from many tables. As you can see I am calling two tables structure and audio. I need to get results from structure, audio, vector and photos. Any clues how I would do this?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

我的奇迹 2024-12-17 00:11:01

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

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

但请确保您在这些表格之间有正确的参考
仔细检查您的结果数据

if you have relationship in those tables then you can use joins to get data from multiple table

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

edited as per comment from user

you can do nesting of inner join for example

    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