Finally a couple of custom view like: SELECT attendee.name, macs.mac FROM macs INNER JOIN attendee ON (macs.attendee_id = attendee.id)
That just about wraps it up for now. > Thanks Dan (and the other DB experts that have helped oto create the > industrial strength register DB), this has been a useful MySQL revision > exercise for me and a fun lunchtime MySQL hussle, I am about to re-run the > script after incorporating your suggestions, I won't post the finished > script again, unless any one wants to see it? - I don't mind... > Ah... s/oto and hussle/to and hustle/ (no references to the definitions found in http://www.urbandictionary.com/ intended though well typo'd this time I thought). -- http://www.diap.org.uk - distributed backup volume management system. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --------------------------------------------------------------