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

Question

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