never mind, sorted all the rest out myself.. the resulting query =
SELECT employment.name AS JOB, skill.name AS SKILL_REQUIRED
BTW I really hope the examples supplied are only test not live data. In which case I would still take care. I heard of a case in England where a developers of a high end financial package added
a test client called "Rich Bastard" to the client list, and a very unfortunate error in coding actually sent
letters to the most important clients each headed up "Dear Rich Bastard".....(The developer got fired).
Beyond Data Systems
[EMAIL PROTECTED]
Ph 64-3-3654656 or 027 436-7702
Fax 03-3793340
