Combining two tables without similarity

[amalina]

Hi,

Is it possible to create a view using two tables without similar column.

I need to combine task & new_call table to get a full list of My request.

Any idea?

Thanks in advance for the help.

[randrews]

interesting just loaded new_call into my dev instance and it does NOT extend task...

we moved new call into task on our instance because.. well it makes sense.. this did create some problems and was a huge issue.. so i can't say i recomend it.. but without that it is going to be problematic to create a view of the two tables.. i may play with it a bit in my dev instance.

[randrews]

ok you CAN do a database view to link all new calls related to a task record.. by linking the data base view..   cll_transfered_to == tsk_sys_id

you could also create a database view that links users to task to new call via the caller/requested for fields but that one would be anoying to write... first link the user table.. then incident, request, problem, change etc.. .this will be annoying because the user is in different locations on each sub table...

you COULD do a user to task to new call HOWEVER that would be a VERY complex where clause.

[syahir]

Hi Amalina.. did u manage to settle this problem? i have the same requirement and mind if you can share your solutions.

Regards.