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

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.

SELECT ...
FROM schedule
INNER JOIN treatment ON ...
LEFT JOIN invoice ON schedule.id_invoice = invoice.id_invoice
WHERE schedule.date ...

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 ?