General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Query for Joining tables
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only