带有where子句参数的SQL Query [英] SQL Query with parameters to where clause

问题描述

我想知道是否有人会帮助我，我试图将表格链接在一起以获取一些信息来制作报告。但我刚接触sql所以需要一些帮助来尽快完成这个：

Hi,

I wonder if anyone would help me out here, I m trying to link tables together to get some information to produce a report. But i m new to sql so need some help completing this asap:

select * from tvdba.mdd_media, tvdba.mdd_containers, tvddba.mdd_media_contnrs_link
where m.media_id = l.media_id (+) --not sure here if i should do where media_id(media_id like ''%'' +....--

我想加入初学者的查询！



例如，我想选择以下项目：

媒体ID

系列标题

格式

版本

位置

文件名

状态



任何想法如何解决这个问题，都会非常有帮助，让我有所帮助。



提前致谢

I want to join the query for starters!

So for example, i want to select the following items:
Media ID
Series Title
Format
Version
Location
Filename
Status

Any ideas how to go about this, would be very helpful, something to start me off.

Thanks in advance

推荐答案

加入的工作基本上是这样的：



SELECT TableA。*，TableB。*，TableC。*，TableD。*

FROM TableA TA

JOIN TableB TB

ON TA.aID = TB.aID

加入TableC TC

ON TA.cID = TC.cID

JOIN TableD TD

ON TA.dID = TD.dID

TAERE_ID_id LIKE ......

Join works basically like this:

SELECT TableA.*, TableB.*, TableC.*, TableD.*
FROM TableA TA
JOIN TableB TB
ON TA.aID = TB.aID
JOIN TableC TC
ON TA.cID = TC.cID
JOIN TableD TD
ON TA.dID = TD.dID
WHERE TA.media_id LIKE ...

这篇关于带有where子句参数的SQL Query的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！