--- In ib-support@y..., "Steven D. Smith" <sds07@h...> wrote:

>
> Wouldn't it be more convenient to build a "telephone" table with cust_id as
> the PK???

The one I provided is a semplification of the problem, just to not annoying you reading not relevant details. No, I can't, and I explicitly told in the post to avoid unuseful reply (...(so it's a sort of

> "lookup" field but with a complex elaboration, so I can't take it directly from a table).)

Maybe you, like I usualy do, don't read the questions very carefully ;))
Thanks for your help anyway
Regards
Marco Menardi

>
>
>
>
> "mmenaz"
> <mmenaz@lycosmail To: ib-support@y...
> .com> cc:
> Subject: [ib-support] How use a SP as a column lookup in a query?
> 05/28/2002 10:19
> AM
> Please respond to
> ib-support
>
>
>
>
>
>
> 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?
> Thanks
> Marco Menardi
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@e...
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/