Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MySQL - SELECT with JOINs

1 view
Skip to first unread message

ProBowlUK

unread,
Mar 15, 2009, 3:44:42 AM3/15/09
to
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 ?

ProBowlUK

unread,
Mar 15, 2009, 4:13:06 AM3/15/09
to
0 new messages