> with the help of everyone here... i was able to get
> this to work...
>
> SELECT DISTINCT t_emp.emp_id, t_emp.first_name || '
> '
> || t_emp.last_name, t_pos.pos
> FROM t_emp, t_pos
> WHERE t_emp.pos_id = t_pos.pos_id
> AND (t_pos.pos = 'Assembler'
> OR t_pos.pos = 'Quality Inspector'
> OR t_pos.pos = 'Test Technician')
...until i tried to stuff the resultset into an array.
I received the following error.
Call to a member function on a non-object
so i ditched the DISTINCT and the results were still
as expected and i can put the resultset into an array.
the "final answer" code (for the moment, anyway -lol-)
is:
SELECT t_employee.employee_id, t_employee.first_name
|| ' ' || t_employee.last_name, t_position.position
FROM t_employee, t_position
WHERE t_employee.position_id = t_position.position_id
AND t_position.position IN ('Assembler', 'Quality
Inspector', 'Test Technician')
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
