Hi!!
I am stuck with a query.
I have one table with company name, product name, and quantity (This is a list of all products that have been purchased). I have another table which also has all these fields and a few other related fields (This table stores the list of products which have been assigned to someone, in other words, they are being used).I want the user to input the company name and product name.I need to compare total quantity of the product(value passed by user) purchased for the particular company(comes from table1) and how many of the products(user input product) are in use(comes from table 2). I want all this to come from a single query.
Is it possible?
Please let me know if my requirement is not clear.
Thanks.