i have two datasets, i'am working on delphi+mssql, with TAdo components



for example

first dataset:
SQL = select a.F1,a.F2
FROM T a

second dataset:
datasource = datasource1
SQL = select b.F1
FROM T b
WHERE b.F1 = :a.F1

if i create master slave sql relations with this maner ( up ), then nothing works normally, but when i create an Alias in first SQL then all works normally, why ?

works normally for me if:
first dataset:
SQL = select a.F1 AS FFF,a.F2
FROM T a

second dataset:
datasource = datasource1
SQL = select b.F1
FROM T b
WHERE b.F1 = :FFF