Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hi
to concatenate the tables MOF_COMM_NO_RANGE and VIEW_COMPLETE_FZ_STRING.
write
rowno() as key
in both table.
Concatenate is same as PL-SQL "Union". To concatenate 2 tables, make sure that common fields have same field names.
Vikram
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.
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.