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 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 them, but this seems less than efficient. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
