🚀 go-pugleaf

You should have one dataset and one DBGrid. In dataset use query like

SELECT [Department Name], FirstName & Chr(32) & LastName AS Name FROM
Departments LEFT JOIN Employees ON Departments.[Department ID] =
Employees.[Department ID] ORDER BY [Department Name]

This sample is for Jet (MS Access) database. Look for help on JOIN in
documentation for your database. Look also help for LEFT JOIN, RIGHT JOIN,
INNER JOIN.

Then you will have columns from both tables.

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

"Uros Obradovic" <ouros@hotmail.com> �������/�������� � �������� ���������:
news:3d21ee9d_2@dnews...
> So what should I do ? I really need this control. Should I try to create a
> new one or is there something else I could use ?
>
> Thanks
> Uros
>
>
> "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
> news:3d21666a_2@dnews...
> > That is not possible. You SQL join query to have one dataset containing
> all
> > columns you need.
> >
> > Regards,
> > Vassiliev V.V.
> > http://www.oledbdirect.com
> >
> >
> > "Uros Obradovic" <ouros@hotmail.com> �������/�������� � ��������
> ���������:
> > news:3d21274c$1_1@dnews...
> > > Is there a way to have 1 (one) DBGrid control on my form but to be
> > connected
> > > with 2 (two) DataSets.
> > > Lets say I have 2 tables, Contacts and Company and they both have the
> same
> > > field ID. Can I have in my DBGrid these two tables connected inside
this
> > > control or thats impossible.
> > > If is possible, would you please give me an example or give me an URL
of
> > > same.
> > >
> > > Thank you
> > > Uros
> > >
> > >
> >
> >
>
>