MySQL Forums
Forum List  »  General

Re: Help - complex joins
Posted by: Bad Programmer
Date: June 02, 2020 05:41AM

You're the MAGIC MAN!
It worked! I took a look at about 15 records (all dummy data).
Both the counts and averages were exactly right.
I could tell it was right from the results immediately after I ran the query.

You made the join with the employee table directly with the answers table. That solved the problem. I guess I didn't think the records would come out right that way. They did.

I started with VB 4.0 & DBase. Through ASP ASP.NET VB.NET, C#.NET, JAVA, MS Access, MS Sql Server, Firebase & a myriad of other databases. Now I'm a full stack PHP, MySql web developer - pretty much all database apps. I'll never figure it all out. This is the toughest join I've ever had to do. It's also my favorite now :) It tells an intense story.

You make it look easy. Thanks very much for your help.

Options: ReplyQuote


Subject
Written By
Posted
May 27, 2020 01:44PM
Re: Help - complex joins
June 02, 2020 05:41AM
June 02, 2020 10:00AM
June 02, 2020 08:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.