maybe something like: select table1.ID AS userid1, table2.ID AS Userid2 from user table1, user table2
?? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Paul Johnston <[EMAIL PROTECTED] To: [EMAIL PROTECTED] tions.com> cc: Subject: [ cf-dev ] MySQL query brain melting... 30/06/2003 15:57 Please respond to dev 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]
