Question

Having this problem, I don `t know how to pull data from multiple tables. I tried to use INNER JOIN and UNION. Here is what I came so far:

select `name_ganre` from `teleprogram`.`ganres`
where `idganre`=any(select `idganre` from `teleprogram`.`ganre-transfer` 
where `idtransfer`=any(select `idtransfer` from `teleprogram`.`broadcasting`));

select `name_channel` from `teleprogram`.`channel` 
where `idchannel`= any(select `idchannel` from `teleprogram`.`broadcasting`);

我需要把频道用一个栏目。并且是另一个名字。

broadcasting 
rows: idtransfer, idchannel

transfer
rows: idtransfer, name_transfer

ganre-transfer
rows: idganre, idtransfer

ganre
rows: idganre, name_ganre

channels
rows: idchannel, name_channel

I m trying to get the data through broadcasting. May be simplified? After the query: name_channel, name_ganre

谢谢!

Answer 1

你们需要的是:

select c.name_channel, g.name_ganre
from channels c
inner join broadcasting b on b.idchannel = c.idchannel
inner join ganre-transfer gt on gt.idtransfer = b.idtransfer
inner join ganre g on g.idganre = gt.idganre

您可看到<条码>。 http://www.w3schools.com/sql/sql_join_inner.asp“rel=” 页: 1

友情链接