[thelist] ASP: More Selective Select

Paul Cowan evolt at funkwit.com
Wed Jul 2 21:30:02 CDT 2003


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



More information about the thelist mailing list