Joining Sp and a Table

[Kid_in_Cognos]

Hi,

i want to join a SP with the table. But there is no column between them.
Please find the attachment for the data items. I need all the data items in UP_CONF_UC_ATPEmailCustomers and one data item in DimClientSym.
is it possible to join these two with out any common column?

Thanks.

[New_Guy]

Hi,
You will need a common column for any kind of join. Do you have any other table that has a related column with the stored proc?
Good luck
New guy

[Lynn]

Can you describe how the join should work without a common column?

[Kid_in_Cognos]

is there is a possibility to create a dummy data item in both the table  and join both?. i thought of like this . But i know i am wrong

Thanks

[Lynn]

is there is a possibility to create a dummy data item in both the table  and join both?. i thought of like this . But i know i am wrong

Thanks

How do the rows returned by the SP relate to the rows returned from the table? Are you trying to join every row in one with every row in the other? A dummy item can be created for that purpose but looking at the structure of both it doesn't look like that would be a sensible thing to do.

[Kid_in_Cognos]

Hi Lynn / New_Guy,

Thank you much for your replies. I have joined the SP and the table by using  another common table and write the query in sql and given the sql generated report output to the customer. He seems to be happy.

Thanks again for your time.

Kind Regards