SELECT a.*, b.first_name, b.last_name FROM jobs a, employees b WHERE... if you want to start somewhere with database : don't use plurial for your table names. It's part of the concept, it's THE job, THE employee that you aim to best describe (with your fields). Cordialement, Damien COLA http://www.VarMalin.com -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Casey Crookston Sent: jeudi 3 juillet 2003 03:21 To: thelist at lists.evolt.org Subject: [thelist] ASP: More Selective Select 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 -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ Evolt.org conference in London, July 25-27 2003. Register today at http://evolt.org.uk For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !