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/