fusion among people who
have limited SQL experience).
HTH,
Tore.
- Original Message -
From: "Diver8" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 4:36 PM
Subject: RE: Unknown table in field list
> Jon and Tore, thanks so much for your k
Jon and Tore, thanks so much for your kind help. I
greatly appreciate it.
I still have one bit of confusion about this whole
thing. I'm reading through the manual as I type this
so maybe I'll find the answer. If someone can help
clarify, I'd appreciate that as well.
Running this query:
mysql>
Just what it says.
Your first query attempts to list a column from a table that is not selected
from (building).
Your second query attempts to assign the alias "building" to both the
parcels table and the building table, and then subsequently does a join on
the building table.
Use the following
Change the query to:
SELECT parcels.DXF as 'record',
building.ADDRESS as 'results1', parcels.relname as
'results2' from parcels INNER JOIN building
on parcels.DXF = building.DXF where
parcels.relname LIKE '%jones%' order by
parcels.relname desc;
For tables in the from list, the next word after a
