[thelist] ASP: More Selective Select

Casey Crookston casey at thecrookstons.com
Wed Jul 2 21:21:24 CDT 2003


Hello Again,

Okay... I have an SQL statement that begins like this:

SELECT * FROM jobs a, employees b WHERE .......

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!

What would the syntax be?

Many TIA's,

Casey



More information about the thelist mailing list