I have to submit the assignment and I get stucked, so I need urgent help. Down is the Question. I have done a Query called Mtangoo_shop_query but I don't know what to do to filter out other fruits and leave only banana. Help! (Believe me MS Access is too complex!) :(
Given the fruit database (Access 2000 version) required to define the following queries using Design View.
1. Select shops that sell bananas; in the result, only include shop identifier, name and city.
2. Select shops that sell orange fruits; in the result, only include shop identifier, name and city.
3. Select wholesalers that wholesale fruits to shops, in the same city that sell both bananas and orange fruits; in the result only
Include wholesaler identifier, name and city. Make sure the result does not include duplicate values.