Regarding the Concatenation

[#1]

Hi friends,

I hve attached the screenshot of the data model  i need to concatenate the  tables  MOF_COMM_NO_RANGE and  VIEW_COMPLETE_FZ_STRING , so pls anyone suggest how can i achieve this.  The unique  FIELD is commssion number.

Thanks & Regards,

Nikitha Jain M.B

[AbhijitBansode]

Nikitha,

From your attachement, I dont see a common filed 'commssion number' between tables MOF_COMM_NO_RANGE and  VIEW_COMPLETE_FZ_STRING.

It is common between these two tables:

POA and  VIEW_COMPLETE_FZ_STRING.

Why do you want to concatenate these tables?

Regards,

Abhijit

[#3]

hi

to concatenate the  tables  MOF_COMM_NO_RANGE and  VIEW_COMPLETE_FZ_STRING.

write

rowno() as key

in both table.

[vikram_patro]

Concatenate is same as PL-SQL "Union". To concatenate 2 tables, make sure that common fields have same field names.

Vikram

[sujeetsingh]

Just ensure that both tables should have common columns.

See the sample i have done both Join and Concatenation .

See what you want for your model.

[#6]

Hi,

as per my knowledge, %_MOF_KEY is the Commission number.

but you have to explain y u want to concatenate or join. without having any info not easy to design the data model structure.