>I'd also suggest to everyone, who doesn't have it, picking up a copy of Joe >Celko's "SQL For Smarties", as it contains lots of neat SQL stuff, the vast >majority of which will run in RBase. The ones that don't, if I recall, are >for the most part, from SQL (proposals) after ANSI-92.
You have to be careful with complex SQL commands in RBase. Last year we discussed one on this list that looked like it worked, produced no error messages, but when subjected to scrutiny was sometimes providing erroneous results and sometimes providing correct results depending on how the data was organized. Be sure to test complex queries with differently ordered versions of the same data set before accepting the query results as valid. If you test the query on two or more orderings of the same data set and get the same results each time, then it is fairly safe to believe the process is valid. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
