[SQL] Order of items in FROM causes error?

2005-04-01 Thread Rosser Schwarz
A colleague has the following query, which errors with: relation dl does not exist. (See the second item in the FROM clause.) If that item is moved to immediately precede the first JOIN item however, the query works as expected. select u.usersfirstname || ' ' || u.userslastname as

Re: [SQL] Order of items in FROM causes error?

2005-04-01 Thread Stephan Szabo
On Fri, 1 Apr 2005, Rosser Schwarz wrote: A colleague has the following query, which errors with: relation dl does not exist. (See the second item in the FROM clause.) If that item is moved to immediately precede the first JOIN item however, the query works as expected. select

Re: [SQL] Order of items in FROM causes error?

2005-04-01 Thread Tom Lane
Rosser Schwarz [EMAIL PROTECTED] writes: A colleague has the following query, which errors with: relation dl does not exist. (See the second item in the FROM clause.) If that item is moved to immediately precede the first JOIN item however, the query works as expected. select