lordvader Posted August 3, 2008 Share Posted August 3, 2008 I'm exploring inner joins. This guy's wordpress plugin code has an inner join like this: FROM (((($wpdb->posts INNER JOIN $wpdb->term_relationships ON $wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) INNER JOIN $wpdb->terms ON $wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)) So I'm wondering if that's the same as: FROM $wpdb->posts INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) INNER JOIN $wpdb->terms ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id) thx Link to comment https://forums.phpfreaks.com/topic/117983-are-these-two-inner-joins-the-same/ Share on other sites More sharing options...
fenway Posted August 5, 2008 Share Posted August 5, 2008 Yes, all those extra parens do nothing in this case. Link to comment https://forums.phpfreaks.com/topic/117983-are-these-two-inner-joins-the-same/#findComment-608987 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.