Hi, thank you; I think the answer may be easy, but at this point my brain in numb.
I merged two tables where some fields are null for some records. When there's more than one line for a record, I need to merge them to show the info in a single line.
The union query looks like this:
Record FieldBefore FieldAfter Rec 1 abc (null) Rec 1 (null) 123 Rec 2 (null) 857 Rec 2 zzz (null)
How can I get the following display:
Record FieldBefore FieldAfter Rec 1 abc 123 Rec 2 zzz 857
Thank you
I really appreciate your advice!
Leonel