Formatter - JOIN ON

"ss052111" <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <[email protected]>
Does anyone know if the Formatter options may be set to keep the ON keyword on the same line as the JOIN clause? I've been looking, but have had no luck. Here's an example of what I'm trying to do:

SELECT pty.party_id
      ,pty.last_name
      ,pty.first_name
      ,pa.street_address
      ,pa.city_name
      ,pa.state_code
      ,pa.zip_code
      ,pe.email_address
  FROM party pty
       INNER JOIN party_address pa ON pa.party_id = pty.party_id
                                  AND pa.address_type_id = 1
       INNER JOIN party_email pe ON pe.party_id = pty.party_id

Of course, if this is not currently possible, I would like to formally lobby for an enhancement. :)

Regards,
Sean




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.