help with joining SQL statements

[iamstupid]

hey guys,
i am having problems in joining these 3 sql statements:

Select NTradeDate, NValueDate, NMaturityDate, NTenor, NoteCurrency, NFaceValue, FCouponRate From tblStrucutredNotes where NseriesNo = SeriesNo

Select SecurityCode, SecuirtyPrice FROM tblUnderlyingStocks WHERE SSeriesNo = SeriesNo

Select EDSEndDate, EDSCouponDate, EDSKO, EDSStrike FROM tbl_EDS WHERE EDSSeriesNo = SeriesNo

Any help would be much appreciated!