create multiple html table using procedure and send email

Question

Hi, I have a query that we have some PO's in two table 

I have to compare the PO in both the table if there is some missing Po in 1st table than send an email and is there is no missing PO than alse send an email i.e no missing PO

so my query is create a html table for both when PO is mising and also for PO that  are matching in both the tables

Following Purchase Orders are not in INFOR

Report generated on : 30 Nov 2021

Missing Items

S.NO	PurchId	LineNumber	ItemId
1	PO-004128	26	00277H-2
2	PO-004128	30	00277N-1
3	PO-004128	38	00277D-1
4	PO-004128	6	00277E-1

and 

PurchId

PO-004128

above PO is present in both the table

but I create procedure it execute like this

Following Purchase Orders are present INFOR and AX

Report generated on : 30 Nov 2021

Missing Items

PurchId

PO-004128

means it jumps to matching po and ignore the missing items query. I have attach my query