SQL for No Transaction
GQApr 18 2011 — edited Apr 18 2011Dear All,
I have two tables 1. Cities 2. Transactions. There are 100 cities and each city is having minimum 100 transactions per day. Transaction table contains city name which is same in Cities table. I want to write a query which should tell me which city has made NO TRANSACTION on any particular day. How application works if there is any transaction it inserts row for each transaction in Transactions table if no transaction no entry in Transaction table. I am looking for those cities who are not having any activity or transaction in a said day.
Can any one help on this and I will really appreciate any one's help in this regards.
Thnaks