Consult select Grammar Em14 : : A table : T1 t2 segments A aa aaa B bbb bb C cc ccc B table : T1 t2 segments A ee eee B ff fff C gg ggg D hh hhh E ii iii The need to link the two lists : T1 at2 at3 corn bt3 A aaa aa ee eee B bb bbb ff fff C cc ccc gg ggg D 0 0 hh hhh E ii iii 0 0 Sentence will select how to write? Xianxie! Em14 : : Consult select Grammar Select bt1, at2, at2, corn, bt3 from a, b Where at1=*bt1 Consult select Grammar Changed a bit : Select bt1, isnull (at2,0), isnull (at2,0), corn, bt3 from a, b Where at1=*bt1 Consult select Grammar Thank you both! [ Closed window ]