Re: LEFT JOIN / USING doesn't work
- From: "Rob Verschoor" <rob@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 8 May 2007 23:36:29 +0200
"yawnmoth" <terra1024@xxxxxxxxx> wrote in message
news:1178659464.798373.127680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT * FROM location_stock LEFT JOIN stock USING (stock_num)
Why, when I run that, do I get this error back?:
Sybase: Server message: Incorrect syntax near the keyword 'USING'.
(severity 15, procedure N/A)
stock_num is a column common to both location_stock and stock. Isn't
that the only requirement USING really has?
ASE doesn't support 'USING'. Try a regular ON-clause instead:
SELECT *
FROM location_stock t1
LEFT JOIN stock t2 on t1.stock_num = t2.stock_num
HTH,
Rob V.
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (new edition!)
"The Complete Sybase ASE Quick Reference Guide" (new edition!)
"The Complete Sybase Replication Server Quick Reference Guide"
mailto:rob@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
.
- References:
- LEFT JOIN / USING doesn't work
- From: yawnmoth
- LEFT JOIN / USING doesn't work
- Prev by Date: LEFT JOIN / USING doesn't work
- Next by Date: Sybase DBA experts required...
- Previous by thread: LEFT JOIN / USING doesn't work
- Next by thread: Sybase DBA experts required...
- Index(es):
Relevant Pages
|
|
