Hi Guys,
I have an easy doubt..
Table A consist of field Item and Table B consist of field Price. Table A
consists of Items which has price aswell the items which doesnt have price.
But In Table B,I have kept only the item which has price . Now, I want to
subtract the total items in Table A to the total items in Table B. so I get
the items which doesnt have price. I used union its not working.. can any of
u guys write the code for it,,,
For example
Table A
Item Book
Pencil
Table
Table B- which consists of Item with price
Price -Book-11 dollar
Pencil-2 dollar
Please reply me asap. I hope it should be v. easy enough to tackle.
Cheers,
Renish koshy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
