F
FSUrules2883
I am trying to combine two tables but when i get to a text field it
returns a null value. Is there any way to get the query to return how
I want it?
Table 1
Customer TEXT TEXT2
A1 A123 A345
C1 A234 A567
A1 A345 A678
A1 A456 A789
Table 2
Customer TEXT TEXT2
E1 B987 B654
F1 B876 B543
E1 B765 B432
What I want to be the returned value
Customer TEXT TEXT2
A1 A123 A345
C1 A234 A567
A1 A345 A678
A1 A456 A789
E1 B987 B654
F1 B876 B543
E1 B765 B432
What I get
Customer TEXT TEXT2
A1
C1
A1
A1
E1
F1
E1
returns a null value. Is there any way to get the query to return how
I want it?
Table 1
Customer TEXT TEXT2
A1 A123 A345
C1 A234 A567
A1 A345 A678
A1 A456 A789
Table 2
Customer TEXT TEXT2
E1 B987 B654
F1 B876 B543
E1 B765 B432
What I want to be the returned value
Customer TEXT TEXT2
A1 A123 A345
C1 A234 A567
A1 A345 A678
A1 A456 A789
E1 B987 B654
F1 B876 B543
E1 B765 B432
What I get
Customer TEXT TEXT2
A1
C1
A1
A1
E1
F1
E1