> Do you mean that I should replace SELECT * FROM > with SELECT field1, [field2],[...] FROM?
Yes. > If so, I need to specify the table name like SELECT > Clients.Name correct? You only need to do that when 2 tables have the same column name. In general, though, it's good practice to always include the table name when joining multiple tables. > Also, how can I access to Quotes.QuoteID and Products.QuoteID? Use aliases (which can be anything; I'm just replacing the '.' with a '_' below) SELECT Quotes.QuoteID AS Quotes_QuoteID, Products.QuoteID AS Products_QuoteId FROM ... Thnx, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
