[V4RB] Querying two related tables

[Eric Ferrer]

Hello all,

I need to display a list of Quotations along with the Names of the
corresponding Clients.
Here is the SQL statement I found:

SELECT QuoteNumber, Name FROM Quotes, Clients WHERE Quotes.ParentClientID =
Clients.ID ORDER BY QuoteNumber DESC

It works fine, excepting that the returned cursor skips Quotations that do
not have parent client (Quotes.ParentClientID = ''), which is bad for me
because my application must allow the creation of Quotations without Client.

Thanks in advance for your help
Eric