Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    4

    Unanswered: MySQL - What query to get a result

    Hello everybody

    I think if there is any query to get some result
    please find enclosed file. I suppose that is easier to understand my question
    when you look in my picture.

    thanks in advance
    Andrzej
    Attached Thumbnails Attached Thumbnails what_query.PNG  

  2. #2
    Join Date
    Oct 2010
    Posts
    8

    ^^

    Please, try to post your queries in order to atleast get a proper view about your problem; images in thumbnails just is not very proper.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    SELECT ...
    FROM schedule
    INNER JOIN treatment ON ...
    LEFT JOIN invoice ON schedule.id_invoice = invoice.id_invoice
    WHERE schedule.date ...
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  4. #4
    Join Date
    Aug 2010
    Posts
    4
    thanks for your support "aflorin27",
    finally I've found the solution but
    your query is much more easier and the result is perfect.

    by the way,
    in case of my question 2 "Would be perfect to get .... " ( see my first post point 2. )
    is not possible to get it by query ?
    Attached Thumbnails Attached Thumbnails q_result.PNG  
    Last edited by andrzej_f; 10-28-10 at 17:24.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •