I am trying to retrieve some rows from two SQL Server 2000
using a SELECT statement with a JOIN. When I try to validate
the script in the editor, I receive an error stating that
"keyword was not found". This only seems to happen when i use
the join. Straight SELECT queries work fine. Is there a way to
use a join to retrieve data with 24x7?

Please ignore this post. The problem was not with the SQL code but a
newline character which was entered from another editor being used to
edit the SQL code.

: I am trying to retrieve some rows from two SQL Server 2000
: using a SELECT statement with a JOIN. When I try to validate
: the script in the editor, I receive an error stating that
: "keyword was not found". This only seems to happen when i use
: the join. Straight SELECT queries work fine. Is there a way to
: use a join to retrieve data with 24x7?