带有where子句参数的SQL Query

本文介绍了带有where子句参数的SQL Query的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想知道是否有人会帮助我，我试图将表格链接在一起以获取一些信息来制作报告。但我刚接触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 ...