Problem With Join Syntax

[Albert Padley]

I have the following table schema in MySQL 4.1.18 which I didn't  
create, but have to work with.

CREATE TABLE `phplog_userinput` (
  `id` int(11) NOT NULL auto_increment,
  `inputfieldid` int(11) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `value` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
A typical set of data looks like this:

id | inputfieldid | userid | value
1          1           2     John
2          2           2     Smith
3          3           2     [EMAIL PROTECTED]

I am trying to come up with a query to return all the `values` of a  
single userid in a single row. I've checked my books, the manual and  
tried every type of join I can think of without success. I'd  
appreciate some direction.

Thanks.

Albert Padley

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]