Coalesce tables?

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?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
"Ryan" wrote:
> 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?
>
>|||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.
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:C1799839-0E0E-477A-AE16-1BBD98A8F04F@.microsoft.com...
> 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
> "Ryan" wrote:
>> 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?
>>