Re: [sqr-users] distinct and oracle hint is sqr

[akshara naik <akshara_naik@yahoo.com>]

Why don't you try

begin-SELECT distinct

 /*+ RULE */  
p.company
p.paygroup
 
from ...


--- RHudgins@genencor.com wrote:
> I would like to do the following
> 
> begin-SELECT 
> /*+ RULE */  distinct
> p.company
> p.paygroup
> 
> from ...
> 
> But sqr  formats it  like this and gives me an error
> -- invalid column -- 
> because it concatenates the distinct and the first
> field.
> 
> SELECT /*+ RULE */  distinctp.company, p.paygroup, 
> 
> 
> I get a error when i move the hint to the same line
> as the begin-select. 
> Does anyone know how to make this work?  Or if it is
> possible.
> 
> 
>   Thanks!
> 
> Rhonda Hudgins
> @}---'----,----
> Genencor International, Inc
> office - 585/256-5266
> rhudgins@genencor.com
> 
>
--------------------------------------------------------------------------
> This message (including any attachments) may contain
> information
> which is confidential or privileged. Use,
> dissemination, distribution, 
> or reproduction of this message by unintended
> recipients is not 
> authorized and may be unlawful. If you are not the
> intended 
> recipient, please advise the sender immediately by
> reply e-mail and 
> delete this message and any attachments without
> retaining a copy.
>
--------------------------------------------------------------------------
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 



        
                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users