🚀 go-pugleaf

You might want to use an INNER JOIN for your query. In your case

SELECT a.Name, b.Type from a, b WHERE a.ID = b.RecordID; or
SELECT a.Name, b.Type from a INNER JOIN b ON a.ID = b.RecordID

Good luck. Lee Gan

"MP" <mpeterka@quick.cz> wrote in message news:3c999534_2@dnews...
> Hi all,
> I'm using  C++Builder 5 and ADO. I'm joining two tables with LEFT OUTER
> JOIN, for example:
>
> SELECT a.Name, b.Type FROM TableA a LEFT OUTER JOIN TableB b ON b.RecordID
=
> a.ID.
>
> The result is shown in a data-aware grid and I need to edit the data. But
> there are some rows from TableA which don't have corresponding row in
> TableB. In this case I need to disable editing the field from TableB (the
> value in grid is NULL and I cannot recognize, if there is row in the
> underlying TableB with NULL value in this field or the row in TableB
doesn't
> exist).
>
> How can I solve it?
> Thanks.
>
> Sorry for my poor English.
> --
> Ing. Miloslav Peterka
> programmer
> ELSYST Engineering
> http://www.el-soft.cz
>
>
> ---
> Odchoz� zpr�va neobsahuje viry.
> Zkontrolov�no antivirov�m syst�mem AVG (http://www.grisoft.cz).
> Verze: 6.0.313 / Virov� b�ze: 174 - datum vyd�n�: 2.1.2002
>
>