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]

Reply via email to