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

[Bob.Melosi@edwardjones.com]

Try  

Begin-Select --+ rule

-----Original Message-----
From: RHudgins [mailto:RHudgins@genencor.com]
Sent: Monday, June 28, 2004 3:48 PM
To: sqr-users
Subject: [sqr-users] distinct and oracle hint is sqr


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


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