Re: Check to see if customer exist in second table. Help needs with psql

On 06/17/2018 12:19 PM, Rv02 wrote: psql I have two tables , table A and Table b. Table A has list of about 6 customers ID with all their details and Table B had customer is and age for over 50 rows of customers. I going to assume you meant Table B has customer ID and age above. Does

Check to see if customer exist in second table. Help needs with psql

psql I have two tables , table A and Table b. Table A has list of about 6 customers ID with all their details and Table B had customer is and age for over 50 rows of customers. I need a query that will take a customer from table a and if that customer exists in table B then insert a yes