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]
