我目前拥有的sql查询如下。我已经尝试了一些联合查询,但是没有用。
Select file_path
from images
where image_id In (
Select image_id
from temp_images
where object_uid IN (
Select object_uid
from object_table
where object_status = 2 and object_place like "%some_keyword%"))`
Select object_uid, object_utitle
from object_table
where object_status = 2 and object_place like "%some_keyword%"`
这两个查询可能返回许多行。我想同时返回file_path和object_uid。
-Image_id | Object_uid | Object_utitle
-img1 | obj1 | 标题1
-img2 | obj2 | 标题2
-img2 | obj2 | 标题3
有什么办法吗?
试试这个:
Select a.file_path, b.object_uid, b.object_utitle
from images a, (Select object_uid, object_utitle
from object_table
where object_status = 2 and object_place like "%some_keyword%") b
where image_id In (
Select image_id
from temp_images
where object_uid IN (b.object_uid) )
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句