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.
Does anyone know of a good tutorial on the Internet that explains the differences between all these different types of joins? I'm a little bit confused with all the options.
Summary: Not being familiar with your SQL environment or your data, my guess is you need to do an outer join: FROM "AB_JOB", "CUSTOMER_ORDER", "OUTER SHEET_SKID", "PRODUCTION_SHEET_ITEM", "SHEET_SKID_DETAI...
Summary: Think I've sorted it. You didn't mention this problem but when I used your code on my sample, I was getting any employees who had 4 changes appearing twice, (as technically they've got two sets of th...
Summary: 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 ...