本文介绍了带有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 ...
更多推荐
带有where子句参数的SQL Query
发布评论