Coalesce tables?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ryan - 25 Jan 2007 20:27 GMT

Hi all,
I'm working with CRM and I need to selectively add one of 5 tables.
Each of these tables have a field called activityid.
I'd like to join only the one with a specific activity ID. Can I do a left
outer join with coalesce?

Reply to this Message

Amarnath - 31 Jan 2007 06:56 GMT

Since coalesce returns the first nonnull expression among its arguments, in
your case it will return first table name only. But I am not able to figure
out why you want tables?

Amarnath

> Hi all,
> I'm working with CRM and I need to selectively add one of 5 tables.
> Each of these tables have a field called activityid.
> I'd like to join only the one with a specific activity ID. Can I do a left
> outer join with coalesce?

Reply to this Message

Ryan - 31 Jan 2007 15:23 GMT

Well I am working with CRM and CRM uses these Filtered views which link in
too many tables. (so many that at some points the report will not run
because too many tables have been linked) Basically there's a central table
that links to 6 other tables, but only successfully links on one of those as
the id from the central table is unique amongst the 6 tables. I was trying
to coalesce this joining so that once it hit the table that has the data it
would stop and not join the rest so that I would not hit my limit of 260
joined tables as I have been.

> Since coalesce returns the first nonnull expression among its arguments,
> in
[quoted text clipped - 10 lines]
>> left
>> outer join with coalesce?

Reply to this Message