Below is my first table in database
CPTCode CPT
80051 82374
82435
84132
84295
and this is my second table in database my requirement is if the CPT Code in my first table has the same cpt code in second table then what is should do is i should color that cpt code in my second table after exporting
also i should check all the cpts of that cpt code and if any cpt's match in both the tables i should color them also that means
Billnum CPT
OCR000967985 80051
OCR000967985 82310
OCR000967985 83690
OCR000967985 84132
OCR000967985 85025
OCR000967985 86140
I have CPT Code 80051 in first table and corresponding cpt's for CPT Code 80051 are 82374, 82435, 84132, 84295 -- this is first table data
In second table i have same bill num OCR000967985 with cpt's 80051, 82310, 83690, 84132, 85025, 86140
if we compare above data 80051 in first table matches with 80051 in second table and one of the cpt for the CPT CODE 80051 matches with cpt's in second table which is 84132 the while exporting i should apply color for 80051 and 84132
as both CPT Code and CPT in first table matches with cpt in second table. Can any one help me out in doing this
What I have tried:
i could not find source for doing this