Results 1 to 3 of 3
  1. #1
    iamstupid is offline Novice
    Windows 2K Access 2003
    Join Date
    May 2011
    Posts
    3

    help with joining SQL statements

    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!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. joining tables
    By frozendmj in forum Queries
    Replies: 5
    Last Post: 04-19-2011, 01:45 PM
  2. Joining more than 2 tables
    By anemoskkk in forum Access
    Replies: 6
    Last Post: 04-17-2011, 04:37 AM
  3. Help - Joining Tables..
    By fabian24 in forum Forms
    Replies: 3
    Last Post: 02-17-2011, 03:43 PM
  4. joining on two userid's
    By svcghost in forum Queries
    Replies: 9
    Last Post: 09-30-2010, 06:48 PM
  5. Joining a Query
    By access_gbr in forum Queries
    Replies: 1
    Last Post: 05-04-2010, 10:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums