I am trying a query using derived tables, but have had little success. Tables follow:
user_table ----------- |user|tbl | ----------- |bud |t2 | |guy |t4 | |abc |t5 | ----------- t2 ------- |a|b|c| ------- |data | ------- t4 ------- |d|e|f| ------- |data | ------- etc... I would like to select data from a table based on information found in the user table, and I am using the following query: select t1.* from (select tbl from user_table where user="guy") t1; This should return the data fom table t4, but I only get results from the subquery (ie. the query returns t4, not it's contents). Where am I going wrong? I am using version 4.1.0-alpha-standard Shawn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
