0

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.

2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by ithelp
0

The problem is no one will do your homework for free whatever excuse you might give it does not matter.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.