Re: Formatter - JOIN ON

Let me try that again:
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
--- In [email protected], "ss052111" <sean.sexton@...> wrote:
>
> 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
>