Olexandr Melnyk wrote:
I din't know about listiтg multiple tables in the JOIN clause up to now, but anyways it looks like QuoteId from the Products table is overriding the same field from the Quotes table. Try to replace the asterisk with an explicit list of fields you want to get.
Hi, thanks for the reply (you should reply to the list also) Do you mean that I should replace SELECT * FROM with SELECT field1, [field2],[...] FROM? If so, I need to specify the table name like SELECT Clients.Name correct? Also, how can I access to Quotes.QuoteID and Products.QuoteID? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
