asked on 12/11/2015

Select, Count & Join

Hi All,

I'm trying to do what feels like the impossible!! I have a query:

"SELECT * from interviewees";
+------------+-------------+----------------------------+-----+-------------+---------------+
| firstname  | lastname    | emailaddress               | RID | candidateid | interviewdate |
+------------+-------------+----------------------------+-----+-------------+---------------+

Open in new window

I am trying (in the same query) to count the number of times the "candidateid" for each result appears in table 'timetable' then join the result as "ScheduleCount". As individual queries I can get it to work, but not as one!

select candidateid,Count(*) as schedulecount from timetable group by candidateid order by candidateid;

Open in new window

MySQL Server Databases

Last Comment

universalmonster

12/14/2015

ASKER CERTIFIED SOLUTION

Jose Torres

12/11/2015

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

universalmonster

12/14/2015

ASKER

The ISNULL part kept erroring on me, but once removed, it worked a treat! Thank you!!

Databases

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

62K

Questions

Followers

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY

Select, Count &amp; Join

Select, Count & Join