Baseball Posted December 25, 2009 Share Posted December 25, 2009 1) I have 2 tables, which i just need to do use SELECT id from table1 were ID = bla bla 2) I innerjoin those 2 tables together? Is it more effeciant for mysql resources to just select what i need from the 2 different tables? Or inner join or left join more efficiant? or it wont really matter? lol Quote Link to comment Share on other sites More sharing options...
ignace Posted December 25, 2009 Share Posted December 25, 2009 Joining two tables isn't much of a concern the cartesian product however is: the more rows it has to return the slower it will become. inner join != left join != right join an inner join will add two records to the result if they have a match left and right join will return all rows from the left or right table regardless if they have a match. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.