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
7 messages in com.mysql.lists.mysqlRE: SELECT from 3 tables - Need help
