On Wednesday 14 June 2006 10:55 am, Albert Padley wrote: > 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.
This sounds like somewhat of a strange requirement. Why do they need to be in a single row? There MIGHT be a way to do it with stored procedures, I'm just not sure how.. > Thanks. > > Albert Padley -- Chris White PHP Programmer/DB Fighter Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
