what information you need sir to add?? every thing is on the screen they are SQL language questions, and for multiple tables to be JOIN using the join obtion, as its compound questions you need to use the where, wsome times wildcard % to join the tables first according to the given table which is attached and then run the query as per questions requirments, if you need a specific,question let me know plwase i will,prepare it for you .