Subject How use a SP as a column lookup in a query?
Author mmenaz
Hi, I would like something like this:
Select cust_id, name, street, telephone from customer

But telephone must be "build" by a stored procedure, that checks some other tables, makes some elaboration, and returns a varchar (so it's a sort of "lookup" field but with a complex elaboration, so I can't take it directly from a table).
If my SP is something like "make_telnum( in_cust_id, out_tel_num)" how can I do that? What is the syntax?
It should be like:
select cust_id, name, street, out_tel_num
from customer
inner join make_telnum(cust_id)
on ?????? on what?

And, is there a better solution?
Marco Menardi