Advanced Search

Return to Snippet

Revision: 43456
at March 24, 2011 07:20 by lastobelus
Initial Code 
select 
users.id, users.sage_username, users.email, 
organizations.id, organizations.name, 
user_gateways.gateway_name, user_gateways.merchant_id, user_gateways.merchant_key, user_gateways.login, user_gateways.email, user_gateways.active, user_gateways.type 
from organizations 
join users on organizations.created_by_id = users.id 
join user_gateways on user_gateways.organization_id=organizations.id 
join 
   (select organization_id, gateway_name, count(gateway_name) 
       from user_gateways 
       group by organization_id, gateway_name 
       having count(gateway_name) > 1) as them 
   on them.organization_id = organizations.id;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
users with more than one of a gateway

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL