Casey Crookston wrote: > But here's the thing... I don't want to select * from employees. I DO want > everything from jobs, but from employees I only need first_name and > last_name. No need to clutter a record set with all that data that will > never be used! SELECT b.first_name, b.last_name, a.* FROM jobs a, employees b WHERE ... Paul