should i concatenate all my 10 table into 1 ?

[#1]

Hi All,

i have 10 table , in my below image only shown 2 table , i like to ask , if all my 10 table have 7 field same name and the rest of 4 field not same name , can i concatenate ? or i re-phase my question , in order to concatenate does it mean that all 10 table field must be similar ? any side effect if some of the field name are diff ?

[rajeshvaswani77 · Accepted solution]

Yes you can concatenate to a single table. The side effect in case there is a different field, then it will add a new column.

thanks,

Rajesh Vaswani

[#3]

Hi Raj

Thank you very much , yes itr work like you said.

Paul