query to show difference of table A and table b.
Posted: Fri Apr 24, 2009 1:39 am
Dear frends,
there are two TABLE A (CUSTOMER_ID) and TABLE B (CUSTOMER_ID,ITEM1,ITEM2,...,ITEM36). Table A stores the permanent customers names. Table B keeps the demand places by any customer in Table A..
I wanted to find out which customers_id only who have not placed demand for items. I was trying do it by Left Join but i cound't...
pls guys help me out.. I m not good at database MYSQL. I want the query for MYSQL.
Thanks with anticipation
Monindra Masia
there are two TABLE A (CUSTOMER_ID) and TABLE B (CUSTOMER_ID,ITEM1,ITEM2,...,ITEM36). Table A stores the permanent customers names. Table B keeps the demand places by any customer in Table A..
I wanted to find out which customers_id only who have not placed demand for items. I was trying do it by Left Join but i cound't...
pls guys help me out.. I m not good at database MYSQL. I want the query for MYSQL.
Thanks with anticipation
Monindra Masia