Working on a Join, but cann't seem to get it correct. Thanks in advance for any help.

I have two identical tables (definition is identical, data is different). I want to join the tables together on fldID. The result table would contain NO duplicate fldIDs. If Tbl1 and Tbl2 both have the same fldID, I want the row from Tbl1, unless Tbl2.fld2 Is not Empty, then I want the row from Tbl2.

Tbl1.fldID Tbl1.fld2
1
2 B
3 C

Tbl2.fldID Tbl2.fld2
2 BB
3
4 DD
5

Result.fldID Result.fld2
1
2 BB
3 C
4 DD
5