I have 2 tables say tableA and tableB
tableA has columns - A,B,C1
tableb has columns - A,B,C2
I need rows from tableA and tableB - A,B,C1,C2
when data is there is either in C1 or C2 or both.

Please suggest how do I write such query.
thanks