i have 3 tables as follows....
1.I want a List of the names of all those cities which has more vendors operating than the number of customers.
2.I want a List the id and name of all the customers who has done a transaction of more than Rs.1 lakh on December 31, 2000 through credit.
pls help me to get the list..
Thanks in advance