Ruslan, > For this you should use LEFT OUTER JOIN > SELECT QuoteNumber, Name > FROM Quotes, Clients > WHERE Quotes.ParentClientID *= Clients.ID > ORDER BY QuoteNumber DESC GREAT! Thank you very much Eric