Post reply

Can't figure out how to write the query!!

  • July 2, 2008 at 10:02 am

    #190042

    I am attempting to write what is for me a very large query. The query will eventually get much more complex so I am trying to break it down into smaller steps. Here is my initial query which works just fine:

    SELECT ci.StmtNum, s.Stmt, s.Count_Range

    FROM tblClientImport ci INNER JOIN

    tblStatements s ON ci.StmtNum = s.StmtNum

    WHERE (tblClientImport.SurveyNum = 1840)

    ORDER BY ci.ReportNum

  • July 3, 2008 at 3:29 am

    #837685

    Ummm... What's your question?

  • July 3, 2008 at 11:11 am

    #838015

    Thats a good Start, but as IAN mentioned.. Whats your Question... Also if possible Pl include Table Scripts and SAMPLE inserts... Pl 🙂

    Maninder
    www.dbanation.com

  • July 3, 2008 at 1:07 pm

    #838092

    This topic is no longer valid!! I started another one yesterday with the heading: Updated Can't figure out how to write the query!! and I received some good replies.

    I have tried to delete this topic but to no avail.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply