ADD SAMPLE DATA TO EMPLOYEESCONTACT TABLE

INSERT INTO EMPLOYEESCONTACT (CONTACTID, EMPLOYEEID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (20001000100001, 5259876, 20222, 1147, ‘YONGE ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘H7A 9A9’, 4164521234, 4164524321, [email protected]);

 

INSERT INTO EMPLOYEESCONTACT (CONTACTID, EMPLOYEEID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (20001000100002, 5258765, 223, 121, ‘ELM ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘A8A 9A9’, 4164521254, 4164512521, [email protected]);

 

INSERT INTO EMPLOYEESCONTACT (CONTACTID, EMPLOYEEID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (20001000100003, 5257654, 215, 365, ‘BLOOR ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘J8J 9A9’, 4164521951, 4164524452, [email protected]);

 

INSERT INTO EMPLOYEESCONTACT (CONTACTID, EMPLOYEEID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (20001000100004, 5256543, 2343, 1245, ‘YONGE ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘A3A 9A9’, 4164521458, 4164524258, [email protected]);

 

INSERT INTO EMPLOYEESCONTACT (CONTACTID, EMPLOYEEID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (20001000100005, 7885432, 20233, 258, ‘ELM ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘M8M 9A9’, 4164521234, 4168744875, [email protected]);

 

INSERT INTO EMPLOYEESCONTACT (CONTACTID, EMPLOYEEID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (20001000100006, 7884321, 2514, 368, ‘FINCH AV’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘Z5Z 9A9’, 4164521684, 4164524486, [email protected]);

 

INSERT INTO EMPLOYEESCONTACT (CONTACTID, EMPLOYEEID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (20001000100007, 7881234, 20282, 1147, ‘FINCH AV’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘Z5Z 9A9’, 4164521419, 4164524941, [email protected]);

Questions