Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Outer joins and join syntax in Visual SQL

2 posts in General Discussion Last posting was on 2009-03-11 14:56:04.0Z
Richard Biffl Posted on 2009-03-08 19:00:36.0Z
From: "Richard Biffl" <sybaseforums@removvethiisphrraseblacklettersoftware.com>
Newsgroups: sybase.public.workspace.general
Subject: Outer joins and join syntax in Visual SQL
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49b415d4$1@forums-1-dub>
Date: 8 Mar 2009 11:00:36 -0800
X-Trace: forums-1-dub 1236538836 10.22.241.152 (8 Mar 2009 11:00:36 -0800)
X-Original-Trace: 8 Mar 2009 11:00:36 -0800, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:812
Article PK: 1088491

Does the Visual SQL tool allow a SELECT statement with an outer join? I
can't find how.

Visual SQL seems to build its queries always with the old-fashioned syntax:

FROM table1, table2
WHERE table1.keyfield = table2.keyfield

Is there a way to make it use the more modern JOIN syntax:

FROM table1 JOIN table2 ON table1.keyfield = table2.keyfield

I'm using SQL Anywhere 10.


"Jeff Pryslak [Sybase]" <jeff.pryslak Posted on 2009-03-11 14:56:04.0Z
From: "Jeff Pryslak [Sybase]" <jeff.pryslak@sybase.com_nospam>
Newsgroups: sybase.public.workspace.general
References: <49b415d4$1@forums-1-dub>
Subject: Re: Outer joins and join syntax in Visual SQL
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49b7d104$1@forums-1-dub>
Date: 11 Mar 2009 06:56:04 -0800
X-Trace: forums-1-dub 1236783364 10.22.241.152 (11 Mar 2009 06:56:04 -0800)
X-Original-Trace: 11 Mar 2009 06:56:04 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:814
Article PK: 1101457

Not with the visual sql builder.

there is an option in the join syntax, the little '=' box in the viewer
above teh criteria, where you can set the =, >, etc... to mimick the type of
join you want.

i like the SQL 99 join syntax as well. it is much clearer.

hth
jeff


"Richard Biffl" <sybaseforums@removvethiisphrraseblacklettersoftware.com>

wrote in message news:49b415d4$1@forums-1-dub...
> Does the Visual SQL tool allow a SELECT statement with an outer join? I
> can't find how.
>
> Visual SQL seems to build its queries always with the old-fashioned
> syntax:
>
> FROM table1, table2
> WHERE table1.keyfield = table2.keyfield
>
> Is there a way to make it use the more modern JOIN syntax:
>
> FROM table1 JOIN table2 ON table1.keyfield = table2.keyfield
>
> I'm using SQL Anywhere 10.
>
>