Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Left/Right Join MYSQL
Name: nicky_blue Date: June 19, 2006 at 22:08:00 Pacific OS: WinXP CPU/Ram: 256 Product: Intel
Comment:
Could somebody tell me how to optimized a Grouped left/ right join in MYSQL Query. i quite dissapointed about it cause same query and data using MS Access is like 3 times faster than MYSQL. i'm using 3.2.58 and intend to keep using that version
Name: jhunt303 Date: June 20, 2006 at 01:36:33 Pacific
Reply:
You really need to index the link fields (really). I can't 'explain' in this little box, but type EXPLAIN before your SELECT statement and look to see if indexes are being used. There are ways to define which table is joined first, again, look at the output of your EXPLAIN command.
Summary: It depends on your database. I am not 100% sure on MySQL, but in Access or SQL 200x you can use a left join / right join command in the from clause. The left join (and there are forums - just search...
Summary: I have two very different reports that I have to run to get all the info out of an inventory database. The first one extracts the current inventory, the second one extracts the user information. I t...
Summary: Message: Thank you lowhanginghoney, I tried it and it got a little further. Using the " to compensate for the spaces, vista came back with another error msg: The filename, directory name, or volume ...
0 
