[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