Display field from another table in SQL
- by Roland Bengtsson
I'm a newbie with SQL...
Now I want to do display some instances of AddrDistances from DevExpress CxGrid with SQL.
Select Cast((DistanceAsMeters * 0.001) as Decimal(8,1)) DistanceAsKm, bold_id, created, fromAddress, toAddress
From AddrDistance
Where DistanceAsMeters = 0 and PseudoDistanceAsCostKm = 0
and not AddrDistance.bold_id in (select…