Hence the "MySQL query" hint in the title. 'tis ok... figured out what I need.
Thx Paul On Mon, 2003-06-30 at 15:02, Tom Smith wrote: > can't use them yet.... this is mysql and views wont be introduced until > version 5.1 > ----- Original Message ----- > From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, June 30, 2003 3:00 PM > Subject: RE: [ cf-dev ] MySQL query brain melting... > > > > if there is no join...use a view > > > > -----Original Message----- > > From: Paul Johnston [mailto:[EMAIL PROTECTED] > > Sent: 30 June 2003 15:57 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] MySQL query brain melting... > > > > > > Ok... I am half asleep... > > > > I have one table of users (let's call it "users" for now)... and I need > > to have a recordset with all rows from the user table, joined with all > > other rows int he user table ie: > > > > userid username > > 1 user1 > > 2 user2 > > 3 user3 > > > > then becomes: > > > > userid1 userid2 ... > > 1 1 > > 1 2 > > 1 3 > > 2 1 > > 2 2 > > 2 3 > > 3 1 > > 3 2 > > 3 3 > > > > Quickly? > > > > Paul > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
