Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Benjamin Petersen — — source: Informix-list mailing list archive (1991-1998)
What is wrong with this SQL (generated by MSAccess) ?
SELECT * FROM stickerinfo RIGHT JOIN stickers ONstickerinfo.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.
Benjamin Petersen,
benjamin@yellow-planner.com
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.