Getting all rows from two tables

[cyberhost]

Hi everybody

I've two tables audio and video and need to get all the rows from two tables by joining. How do i do that.I need all the columns from both the tables. audio_sid and video_sid from both tables are same along with audio_prog_num and video_prgm_num from audio and video tables respectively.

Any inputs will be welcomed -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[pixel]

I have not exactly got your point as you have not explained your table layouts in detail, but anyways, here's the code

select audio.audio_sid
, audio.video_sid
, audio.audio_prog_num
, audio.video_prgm_num
, audio.some_other_columns
, video.some_other_columns
from audio
inner
join video
on audio.audio_sid = video.audio_sid
and audio.video_sid = video.video_sid
and audio.audio_prog_num = video.audio_prog_num
and audio.video_prgm_num = video.video_prgm_numif this isn't exactly -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --