[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
> 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 ...


More information about the thelist mailing list