Forum Discussion
Can I merge two or more table by column and row.
Assuming I have a two table containing the following information: Table 1: Field1 | Field2
=====================
ABC | NULL
NULL | DEF Table 2: Field3 | Field4
=====================
ABC1 ...
Paata1966 , the requirements on the result are unlogical and unlogical is difficult to implement in SQL
Why is table1, field2 = "Def" only once included in the result? Unlogical.
olafhelper Thanks for the answer, I think it's logical enough, I solved the problem using ROW_NUMBER and LEFT JOIN