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

    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
    Attached Thumbnails Attached Thumbnails what_query.PNG  

  2. #2
    Join Date
    Oct 2010


    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
    Iasi, Romania
    Provided Answers: 3
    SELECT ...
    FROM schedule
    INNER JOIN treatment ON ...
    LEFT JOIN invoice ON schedule.id_invoice = invoice.id_invoice
    WHERE ...
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  4. #4
    Join Date
    Aug 2010
    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