complex join

#1

I need to join a table, but use a complex join. For example,
tbl_show s
join tbl_region r on r.system=s.system AND s.zone between r.startzone and r.endzone .
It's not just a standard join of system and zone. (This is a great design for our company in the relational databases, and
we cannot change it.) Can I edit the join somewhere? Suggestions? Thanks in advance! James

#2

Use a view on the backend and build the cube off of the view.

"Sillymellon" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

I need to join a table, but use a complex join. For example,
tbl_show s
join tbl_region r on r.system=s.system AND s.zone between r.startzone and
r.endzone .
It's not just a standard join of system and zone. (This is a great design
for our company in the relational databases, and
we cannot change it.) Can I edit the join somewhere? Suggestions? Thanks
in advance! James

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

complex join

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

complex join - 01-23-2004 , 12:36 PM

Re: complex join - 01-24-2004 , 06:44 AM