How to use join query to fetch data from more than two table

Hi friends,

Once I need your help,

I have three table in my database.

1> wedding

Field Name	Data Type
wedID	Int (Primary Key)
wedName	Varchar(50)

2> siteSelect

Field Name	Data Type
wedID	int
siteID	Int
siteStatus	Varchar(50)

3>webSite

Field Name	Data Type
siteID	Int
siteName	Varchar(50)
siteFile	Varchar(MAX)

"ws" is alias of "webSite" table , "s" is Alias of "siteSelect" Table

all data from "webSite" table and only data from "siteSelect" where s.siteStatus do not display "Yes" if wedID not match

I want out put as followed

ws.siteID ws.siteName ws.siteFile s.wedID s.sitestatus

1 Show show.jpeg 6 Yes

2 My View my view.png 5

3 Dream dream.jpeg 3

I try following sql query

select DISTINCT(ws.siteID),s.wedID,ws.siteName,ws.siteFile,s.siteStatus from wedding wd, webSite ws left outer join siteSelect s on ws.siteID=s.siteID where wd.wedID=@wedID

but Output as follwed

I want out put as followed

ws.siteID ws.siteName ws.siteFile s.wedID s.sitestatus

1 Show show.jpeg 6 Yes

2 My View my view.png 5 Yes

3 Dream dream.jpeg 3 Yes