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]
