ok then....

like this:

if firstname from customer where customerid = 1 matches firstname from person where personid = ... whatever id

THEN

INSERT INTO match (customerid, personid, columnname)

VALUES (customerid, personid, firstname)

then after...

Again thank you, the output I would like is if bob customer id 1 from customer table matches the first name bob from person table with id 27, then insert...

Hello Everyone,

Here is the DDL, again sorry which is exactly the same that was posted except there is an id for both customer and person, and its the identifier and...

Sorry everyone for that, now i understand and will make sure I did that in the future. Ya I pointed out about C# because i know it will help with...

oops sorry yes for the match table its below on how it is, very simple

Match table

Customerid ...

Thank you for the reply, sorry for the missing info, for the tables its below, let me know if you need anything else, for the last reply by SSC Rookie,...