🚀 go-pugleaf

Use Join (Left join, right join, inner join) like

SELECT LName, FName, Name
FROM Person
LEFT JOIN PersonHistory ON Person.PersonID = PersonHistory.PersonID
LEFT JOIN Company ON PersonHistory.CompanyID = Company.CompanyID

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"Uros Obradovic" <ouros@hotmail.com> �������/�������� � �������� ���������:
news:3d35d23e$1_2@dnews...
> Hi guys,
> I'm having with DBGrid, actually I would say I don't know how to do
> following.
>
> In DBGrid control, I have 4 Columns
> - Last Name
> - First Name
> - Company Name
>
> where Last Name and First Name are from one table, and Company Name from
the
> other.
> Last Name and First Name columns are pointing to LName and FName fields in
> Person Table respectively,
> but Company Name is in the other table.
> I would like to use the following SQL statement and have the results in
> Company Name column.
>
> SELECT LName, FName, Name
> FROM Person, PersonHistory, Company
> WHERE Person.PersonID = PersonHistory.PersonID
> AND PersonHistory.CompanyID = Company.CompanyID
>
> How can I do that ?
> Hope you understand my question
>
> Thanks
> Uros
>
>