RE: Unknown table in field list

2003-02-24 Thread Diver8
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>

Unknown table in field list

2003-02-24 Thread Diver8
Hi again. I've tried searching the list archives for this all morning, but they don't seem to be working (never get any results, page times out). I found one report of this on google but the guy said he figured out the problem but didn't say what he did to fix it! I just added a table to my data

Re: Newbie - How To Link Two Databases

2003-02-22 Thread Diver8
> WHERE P.Description = '' > > Or similarly, if you have the Address, and you want > to show the Parcel > Description: > > SELECT P.Description, B.Address > FROM Parcels as P > INNER JOIN Buildings a B > ON P.dxf = B.dxf > WHERE B.Add

Newbie - How To Link Two Databases

2003-02-22 Thread Diver8
Hi - I am new to MySQL & SQL in general. I have been reading the documentation at www.mysql.com, but I've become quite confused. I hope that one of you can clear up a few issues for me. I have a database called "parcel". The primary key in this database is called "dxf", which contains a unique