Re: Outer-join a subselect?

From: craibuc <craibucNOcrSPAM_at_hotmail.com.invalid>
Date: 2000/07/27
Message-ID: <0c75d817.9ce61169@usw-ex0105-035.remarq.com>#1/1

Thanks for the reply. It appears that the in-line view can't reference a table outside of its (). The compiler says that si.year_id is an invalid column. If you add a reference to the ma_site table within the (), then the column is found.

Am I missing something?

Thanks,

Craig

Craig Buchanan
Cogniza, Business Intelligence Specialists www.cogniza.com
+1.612.824.5858

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Jul 27 2000 - 00:00:00 CDT