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!

[June7]

What is the nature of the problem - error message, wrong results, no results. We would have to know more about your table relationships. Where does the criteria SeriesNo come from?

[orange]

What exactly do you mean

i am having problems in joining these 3 sql statements:

Why are you trying to JOIN 3 SQL statements?
Are you talking JOIN, in the concept of joining tables?

Can you describe, in plain English, what you are trying to achieve?
Perhaps there are other options.