Thread: Query query

    #1
  1. No Profile Picture
    matt1174
    Guest
    Devshed Newbie (0 - 499 posts)

    Query query


    I am running, well trying to anyway, a query to give me a report on paperwork raised against a required drawing.

    The problem I'm having is that the query only picks up on fully completed paperwork, and not those half done.

    The example being I ask it to look for paperwork for drawing 12345 - which was completed 2 months ago, so it tells me it was order no 00001 and despatch note 00003.

    However, there is another order for the same drawing, which is still in progress, it has an order number but no despatch note will not show.

    I need to see in the report that is still to be sent.

    How can I do this please?

    The query only seems to like all fields being satisfied
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,178
    Rep Power
    4274
    you need to give a lot more information in order to get help

    show us what your table looks like -- column names and datatypes -- and show us your query

    otherwise we have no idea what you're talking about
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo