el left join no funciona cuando
en Access97

table_1
field1 field2 field3
AA code1 aaaaaa
AA code2 bbbbbb

table_2
field1 field2
XX code1
YY code3

select * from table_2 t2 left join table_ t1
on t2.field_2 = t1.field_2 and t1.field1 = "AA"

or

select * from table_1 t1 left join table_2 t2
on t2.field_2 = t1.field_2
where t1.field1 = "AA"

both returns only one regs, why?