Re: Limiting the data returned to just what I need

2004-03-29 Thread Michael Stassen
Scott Haneda wrote: Wonder if there is a more efficient way of dealing with the following... I have a user table and a serial_numbers table User table has name, address, state, zip etc Serial_numbers table has a id and a serial number. Client wants a "hitlist" that shows the user data and the as

Re: Limiting the data returned to just what I need

2004-03-28 Thread Peter Frank Spierenburg
On Sun, 28 Mar 2004, Scott Haneda wrote: > Client wants a "hitlist" that shows the user data and the associated serial > numbers for a list of users. If the query returns 20 serial numbers, I am > going to get back 19 name, address, state, zip etc rows that I don't need, I > can easily discard th

Limiting the data returned to just what I need

2004-03-28 Thread Scott Haneda
Wonder if there is a more efficient way of dealing with the following... I have a user table and a serial_numbers table User table has name, address, state, zip etc Serial_numbers table has a id and a serial number. Client wants a "hitlist" that shows the user data and the associated serial numb