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