Hi, I have 2 tables to extract data from.

Table 1
______
user_id
group_id
col3
col4

Table 2
_______
user_id
User_fullname
col3
col4
col5
etc...

As simple this may sound, I'm still new so please bare with me. Basically I want to know if a join would be good to use or any other ideas. The extract needs the user_ids from a certain group_id with their user_fullname attached. I guess I want to extract all the users with the specific group_id from table 1 and join the results to table 2 for their matching full name. Suggestions please....

Select a.user_id, b.user_fullname, (add other columns you need here)
from table1 a, table2 b
where a.user_id = b.user_id
and a.group_id = 'xxxxx'

Wow, quick and from and IBM'er himself . Thanks alot worked like a charm. I guess I can come here from now and and ask questions eh, great place.

I don't work for IBM. I have obtained IBM certification as DB2 DBA. This involves taking and passing several exams.

Oh sorry for the confusion. Do those certifications expire like others? I mean do you have to keep updating them?

The certifications are for specific releases of DB2.