Recent content by orangeo23
-
O
Query Design Need Help
Great works like a dream. You are a Star...... Many thx for yours help -
O
Query Design Need Help
Hi, I have been trying to solve from last 8 hours for part 2 but with out any luck, any further help will be appreciated. thx in advance -
O
Query Design Need Help
Many thx it work fine but the 2nd part of Q is remaining. My question is "query that displays the band name, the number of events that they have played at, the number of musicians in the band, the total amount earned by the band and the total amount earned by each band member (assuming that... -
O
Query Design Need Help
Hi, I manage to run Query, but im stuck how to group bands and price together then how to get each musician amount. thx in advance -
O
Query Design Need Help
**************************************************** Here is the screen shot of output after running SQL query. Now how do calculate each musician amount. Thanks for yours kind help -
O
Query Design Need Help
************************************************* Here is my attached database for yours kind consideration. -
O
Query Design Need Help
I have attached database file as well. Please let me know wht to do. yhx in advance. -
O
Query Design Need Help
Im new here so cant post screen shots i need at least 10 post at least -
O
Query Design Need Help
Hi, Here is a situation I have one Musicians table with fields {unionNo PK, Surname, Forenames, Instrument} 2nd Event table with fields {Event Id PK, Price, Group, Venue, Band Name} 3rd Bandmembers table {BandName, UnionNo} 4th Band table {Band Name PK, Price} 5th Group table {Group PK...