The following output is from queries using NOSPRead and
SQLCol=Names.
s--------+---------+---------+---------+---------+---------+---------+---------+
SELECT DISTINCT ABC.STAFF.TLA, ABC.STAFF.SALARY
FROM ABC.STAFF, ABC.HOURS
WHERE (ABC.STAFF.TLA = ABC.HOURS.TLA) AND
(ABC.HOURS.TOTAL > 40)
h--------+---------+---------+---------+---------+---------+---------+---------+
TLA SALARY
d--------+---------+---------+---------+---------+---------+---------+---------+
ACO 20050.00
SJJ 19040.00
and
s--------+---------+---------+---------+---------+---------+---------+---------+
SELECT * FROM ABC.STAFF
h--------+---------+---------+---------+---------+---------+---------+---------+
EMPLOYEE TLA AGE SALARY
d--------+---------+---------+---------+---------+---------+---------+---------+
Steve Jasinski SJJ 23 28040.00
Alison Cook ACO 22 28040.00
Mark Ballam MFB 63 87420.55