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!