using join - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

using join

Author

Topic

Ambikaa
Starting Member

43 Posts

Posted - 2009-03-05 : 01:35:38

Hi,

how to use join in this query

select (tv.EventDate+convert(char(8), tv.BeginTime, 108)) AS BT,
(tv.EventDate+convert(char(8), tv.EndTime, 108)) AS ET ,
Video_id,video_name,video_desc,video_channelid,Video_Thumbnail
from
mdb_Videos v,
mdb_Networks n,
mdb_Channels c,
mdb_Videogroups vg ,
mdb_tvguide tv
where v.video_NetId=20 and v.Video_Approved=1 and v.video_Status=1
and v.Video_Deleted=0 and v.video_Netid=n.net_id and
v.video_GroupId=vg.vgrp_id
and v.video_ChannelId=c.chan_id and
n.Net_Status=1 and n.Net_Deleted=0 and c.Chan_Status=1
and c.Chan_Deleted=0 and vg.Vgrp_Status=1 and vg.Vgrp_Deleted=0 and
tv.eventdate=convert(char(10),getdate(), 110) and tv.videoid=v.video_id
order by convert(char(8), tv.BeginTime, 108) asc

matty
Posting Yak Master

161 Posts

Posted - 2009-03-05 : 01:46:25

select (tv.EventDate+convert(char(8), tv.BeginTime, 108)) AS BT,
(tv.EventDate+convert(char(8), tv.EndTime, 108)) AS ET ,
Video_id,video_name,video_desc,video_channelid,Video_Thumbnail
from mdb_Videos v
JOIN mdb_Networks n ON v.video_Netid=n.net_id
JOIN mdb_Channels c ON v.video_ChannelId=c.chan_id
JOIN mdb_Videogroups vg ON v.video_GroupId=vg.vgrp_id
JOIN mdb_tvguide tv ON tv.videoid=v.video_id
WHERE v.video_NetId=20 AND v.Video_Approved=1 AND v.video_Status=1 and v.Video_Deleted=0
AND n.Net_Status=1 AND n.Net_Deleted=0
AND c.Chan_Status=1 AND c.Chan_Deleted=0
AND vg.Vgrp_Status=1 AND vg.Vgrp_Deleted=0
AND tv.eventdate=convert(char(10),getdate(), 110)
order by convert(char(8), tv.BeginTime, 108) asc

Nageswar9
Aged Yak Warrior

600 Posts

Posted - 2009-03-05 : 01:54:36

(OR)
select (tv.EventDate+convert(char(8), tv.BeginTime, 108)) AS BT,
(tv.EventDate+convert(char(8), tv.EndTime, 108)) AS ET ,
Video_id,video_name,video_desc,video_channelid,Video_Thumbnail
from mdb_Videos v
INNER/LEFT JOIN mdb_Networks n ON v.video_Netid=n.net_id
INNER/LEFT JOIN mdb_Channels c ON v.video_ChannelId=c.chan_id
INNER/LEFT JOIN mdb_Videogroups vg ON v.video_GroupId=vg.vgrp_id
INNER/LEFT JOIN mdb_tvguide tv ON tv.videoid=v.video_id
WHERE v.video_NetId=20 AND v.Video_Approved=1 AND v.video_Status=1 and v.Video_Deleted=0
AND n.Net_Status=1 AND n.Net_Deleted=0
AND c.Chan_Status=1 AND c.Chan_Deleted=0
AND vg.Vgrp_Status=1 AND vg.Vgrp_Deleted=0
AND tv.eventdate=convert(char(10),getdate(), 110)
order by convert(char(8), tv.BeginTime, 108) asc

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources