Ordering 2 recordsets

Here it is the table structure:

tblVisitsDoctors
ID (autonumbered)
strData (Date)
strOra (Time)
strDoctor (txt)
strProdusPrezentat (txt)
strProdusPrezentat2 (txt)
strInput (txt)
strInput2 (Memo)
strObservatii (Memo)
strNote (Memo)
strFeedback (memo)

tblVisitsPharma
ID (autonumbered)
strData (Date)
strOra (Time)
strPharma (txt)
strVorbitCu (txt)
strProdusPrezentat (txt)
strProdusPrezentat2 (txt)
strInput (txt)
strInput2 (Memo)
strObservatii (Memo)
strNote (Memo)
strFeedback (memo)

As you can see, they are almost identical. VisitPharma has 1 field more, but it does not matter. What I need is to display all the visits in the same day, regardles where they were (doctor or pharmacist), ordered by the hour of the visit (strOra). In this common report, there only need to be:
| Person visted (strDoctor or strPharma) | What is visited (Write Doctor if is a doctor or Pharma if it's a pharmacist) | Time of the visit (strOra) | Reason (strNote) | Feedbak (strFeedback) | Full details (a link to display fiull report about the visit) .

Database is MySQL.

If you're dealing with a known universe of Doctors/Pharma's,...

I'd put them in a separate "Provider" table with a autonum key in it that is referenced in the combined detail table. Include the Type Field in the new table.

Ensures that spelling is consistant and that only approved Docs/Pharmas are entered. If at some point you need to add addresses or phone numbers, do it to the Provider table instead of updating all the detail records.

The rule of thumb for most data normalization is that if the same data is going to be used by many detail records, it should be in a separate table.