I am having some weird problem figuring this seemingly simple query out. Here are the two tables from which I have to run the query
Table alpha: id int(3) not null auto_increment, name char(12) not null, primary key(id) example data 1 fred 2 bob 3 sam 4 rita 5 george 6 laura 7 nancy Table bravo: afrom int(3) not null, ato int(3) not null, Primary key(afrom) Example data 1 5 5 7 6 3 in the php variable coming in I have fred and need to run a query to get george. Right now since I'm having so mental problem, I have resorted to running 3 queries. 1 to find the id for fred, one to find the matching id from the bravo table and one to get the name that matches the bravo table result. Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]