In this example, I have two tables (Table A and Table B) and I want to make a third table (Table C) which is basically Table A, and the addition of one column from Table B.   i.e. Table A Customer_ID Customer_Name Customer_Credit_Rating 1 Jane 3 2 Josh 8 3 Jess 8   Table B Customer_ID Facility_ID Security_Type LVR 1 FAC115 A 88% 2 FAC108 A 75% 8 FAC109 D 80% 9 FAC111 E 90% 10 FAC113 F 80%   Makes Table C Customer_ID Customer_Name Customer_Credit_Rating LVR 1 Jane 3 88% 2 Josh 8 75% 3 Jess 8 null   How is this done? I have tried a left join but it results in Table C having more records than Table A.   Thanks in advance ... View more