Selecting info from multiple tables for one unique ID with PHP and MySQL
        Posted  
        
            by Mark
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Mark
        
        
        
        Published on 2010-03-22T00:19:18Z
        Indexed on 
            2010/03/22
            0:21 UTC
        
        
        Read the original article
        Hit count: 710
        
I'm using PHP and MySQL. Is this the best method to select information about "user_1" from four different tables? I know it works, because I have tried it. But is this the preferred method of selecting information from multiple tables for "user_1"?
$query = "SELECT table_1.username, table_2.city, table_3.state, table_4.country
    FROM table_1
    JOIN table_2
        ON table_1.username=table_2.city
    JOIN table_3
        ON table_1.username=table_3.state
    JOIN table_4
        ON table_1.username=table_4.country
    WHERE table_1.username = 'user_1'";
© Stack Overflow or respective owner