crapmyster's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
Active Members
Active Posts:
77 (0.07 per day)
Joined:
12-October 11
Profile Views:
2,314
Last Active:
User is offline Jul 02 2014 01:28 AM
Currently:
Offline

Previous Fields

Country:
Who Cares
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
Intel
Favorite Gaming Platform:
XBox
Your Car:
Who Cares
Dream Kudos:
0
Icon   crapmyster has not set their status

Posts I've Made

  1. In Topic: Select multiple counts from one table and command

    Posted 2 Jul 2014

    Thank you for the information, much appreciated.
  2. In Topic: Select multiple counts from one table and command

    Posted 1 Jul 2014

    Yeah, I understand now. Thank you.
    If for example I wanted to not to join two tables, how would I got about doing it the sub query way.
  3. In Topic: Select multiple counts from one table and command

    Posted 1 Jul 2014

    Right, so I created a temporary table to hold the values of REJECTED, COMPLETE & PENDING.

    I wrote this:

    SELECT s.status, IFNULL(COUNT(*),0) AS amount
    FROM REPAYMENTREQUESTENTITY s
    LEFT JOIN info_values w
    ON s.status = w.v
    GROUP BY s.status;
    
    


    It still did not show up values for the headings that the count should be zero. I even put IFNULL in to see if that made a difference but it didn't. Any help why?
  4. In Topic: Select multiple counts from one table and command

    Posted 1 Jul 2014

    how would I go about doing it the sub query way?
  5. In Topic: Select multiple counts from one table and command

    Posted 30 Jun 2014

    yes, you are right. However, if I did this and there were no PENDING status then nothing would be returned for that heading. When you can't find a status from pending, complete, or rejected it must be zero.

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Click here to e-mail me

Friends

crapmyster hasn't added any friends yet.

Comments

crapmyster has no profile comments yet. Why not say hello?