Ritu Gupta

Ritu Gupta

  • 1.9k
  • 194
  • 5.3k

create multiple html table using procedure and send email

Nov 30 2021 12:24 PM

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


Attachment: missing_Po.rar