 |
 |
Archives of the TeradataForum
Message Posted: Mon, 18 Jul 2005 @ 13:34:50 GMT
| Subj: | | Re: SQL Error: expecting something between ( and the select word |
| |
| From: | | Victor Sokovin |
| | The last part was copied twice. | |
This helps. At least I was able to run the query on Oracle, which probably makes it ANSI compliant (I know this is a wrong logic but it often
works). Not that is is an interesting query, though. As it is, it is not supposed to return any rows. Your first date is always greater than the
second one. Try to swap the expressions to make the query more interesting. Do you still have a problem with it then?
Matthew's syntax works just fine as well, BTW.
Regards,
Victor
| |
