Re: [Q] Problems with Online and SQL-92 joins

In article <351B9C52.62B3E7A1@yellow-planner.com>, Benjamin Petersen <benjamin@yellow-planner.com> writes >What is wrong with this SQL (generated by MSAccess) ? > SELECT * FROM stickerinfo RIGHT JOIN stickers ON>stickerinfo.stickerid = stickers.keyid; > >I can't run it on Online. It gives a syntax error at 'JOIN'.... > >I know that i can do it like this : > SELECT * FROM stickers, OUTER(stickerinfo) WHERE stickers.keyid =>stickerinfo.stickerid > >but this will only run on informix databases and is not using the SQL-92 >standard. > Sorry but that requires more than entry level compliane which is more than Informix has. PS Sybase uses +, there is no standard for outer join syntax. Uses unions instead. >Benjamin Petersen, >benjamin@yellow-planner.com > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care