Access Denied!

2002-01-10 Thread Larry Reiter
I am trying to load some new data into my database and I keep getting this error: ERROR 1045: Access denied for user: 'lreiter@localhost' (Using password: YES) The files I am loading are located in another directory on the server and I used the absolute path to point to them, but I still get an

Nested Queries.

2001-12-20 Thread Larry Reiter
I have constructed a query which requires a temporary table but I would rather use a nested query. In other words, I want to extract a set of data and then use that set of data as a query against some other data. Like some sort of SELECT within a SELECT. Can I do this in MySQL? Cheers, LTR --