This links to an ERD diagram that illustrates a MySQL database schema. www.ProBowlUK.co.uk\images\ERD_001.jpg
They are MyISAM tables, with no Foreign Key contraints (the fk suffix is not used in the actual database). I need to provide MySQL SELECT statements, with various combinations of JOINs, to give the following output ... 1) Who is assigned what assets? 2) What maintenance has been carried out on each asset? 3) Which assets have not undergone any maintenance? 4) Who hasn't been assigned any assets? 5) Which assets have not been scheduled for maintenance? 6) Which employees have been assigned assets for which no maintenance has been scheduled? I have managed to complete the first 2. Making no headway at all with the others. Can anyone give me pointers/examples ? Also, in the first SELECT, is there a way of not repeating an employee's name in the output ? -- I am using the free version of SPAMfighter. We are a community of 6 million users fighting spam. SPAMfighter has removed 12716 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message
