blhfeedback TABLE
| learningHub_Login | blh_feedbck_barangay_locationID |
|---|---|
| Bagong Silang | 1 |
| Bagong Silang | 1 |
| Bagong Silang | 1 |
| Tuyo | 25 |
blh_location Table
| blh_feedbck_barangay_locationID | blh_barangay | blh_if_faciility_open |
|---|---|---|
| 1 | Bagong Silang | 1 |
| 2 | Tenejero | 1 |
| 24 | Cupang North | 0 |
| 25 | Tuyo | 1 |
I’m trying to combine the Count of “LearningHub_Login” column from the blhfeedback table and the blh_if_faciility_open column form the blh_location table using the query below
<code>SELECT
COUNT( blhfeedback.LearningHub_LogIn ) AS 'Total User for Today,',
blh_location.blh_kung_meronngFacility AS 'Active Facility?'
FROM
blhfeedback
INNER JOIN blh_location ON blhfeedback.blh_feedbck_barangay_locationID = blh_location.barangay_location_id
WHERE
DATE( blhfeedback.Login_info_Open ) = DATE( DATE_SUB( NOW(), INTERVAL 0 DAY ) )
AND
blhfeedback.LearningHub_LogIn = 'Bagong Silang'
</code>
<code>SELECT
COUNT( blhfeedback.LearningHub_LogIn ) AS 'Total User for Today,',
blh_location.blh_kung_meronngFacility AS 'Active Facility?'
FROM
blhfeedback
INNER JOIN blh_location ON blhfeedback.blh_feedbck_barangay_locationID = blh_location.barangay_location_id
WHERE
DATE( blhfeedback.Login_info_Open ) = DATE( DATE_SUB( NOW(), INTERVAL 0 DAY ) )
AND
blhfeedback.LearningHub_LogIn = 'Bagong Silang'
</code>
SELECT
COUNT( blhfeedback.LearningHub_LogIn ) AS 'Total User for Today,',
blh_location.blh_kung_meronngFacility AS 'Active Facility?'
FROM
blhfeedback
INNER JOIN blh_location ON blhfeedback.blh_feedbck_barangay_locationID = blh_location.barangay_location_id
WHERE
DATE( blhfeedback.Login_info_Open ) = DATE( DATE_SUB( NOW(), INTERVAL 0 DAY ) )
AND
blhfeedback.LearningHub_LogIn = 'Bagong Silang'
and i successfully combine them and display the column i desired like this
| Total User for Today | Active Facility? |
|---|---|
| 3 | 1 |
but may change my
<code>blhfeedback.LearningHub_LogIn='Bagong Silang'
</code>
<code>blhfeedback.LearningHub_LogIn='Bagong Silang'
</code>
blhfeedback.LearningHub_LogIn='Bagong Silang'
to
<code> blhfeedback.LearningHub_LogIn='Tenejero'
/* OR CHANGE TENEJERO TO THIS */
blhfeedback.LearningHub_LogIn='Cupang North'
</code>
<code> blhfeedback.LearningHub_LogIn='Tenejero'
/* OR CHANGE TENEJERO TO THIS */
blhfeedback.LearningHub_LogIn='Cupang North'
</code>
blhfeedback.LearningHub_LogIn='Tenejero'
/* OR CHANGE TENEJERO TO THIS */
blhfeedback.LearningHub_LogIn='Cupang North'
I’m getting a value of ‘Null istead the balue of blh_if_faciility_open TABLE LIKE THIS
| Total User for Today | Active Facility? |
|---|---|
| 0 | Null |
Is it possible to get the value of blh_if_faciility_open TABLE to my query? or i just made the wrong Mysql jOIN IN MY COMMAND?
2
<code>SELECT
count(blhfeedback.LearningHub_LogIn) as 'Total User for Today,', IFNULL(blh_location.blh_kung_meronngFacility,0) as 'Active Facility?'
FROM blhfeedback
INNER JOIN blh_location ON blhfeedback.blh_feedbck_barangay_locationID = blh_location.barangay_location_id
WHERE date(blhfeedback.Login_info_Open)=date(date_sub(now(),interval 0 day))
AND blhfeedback.LearningHub_LogIn='Bagong Silang'
</code>
<code>SELECT
count(blhfeedback.LearningHub_LogIn) as 'Total User for Today,', IFNULL(blh_location.blh_kung_meronngFacility,0) as 'Active Facility?'
FROM blhfeedback
INNER JOIN blh_location ON blhfeedback.blh_feedbck_barangay_locationID = blh_location.barangay_location_id
WHERE date(blhfeedback.Login_info_Open)=date(date_sub(now(),interval 0 day))
AND blhfeedback.LearningHub_LogIn='Bagong Silang'
</code>
SELECT
count(blhfeedback.LearningHub_LogIn) as 'Total User for Today,', IFNULL(blh_location.blh_kung_meronngFacility,0) as 'Active Facility?'
FROM blhfeedback
INNER JOIN blh_location ON blhfeedback.blh_feedbck_barangay_locationID = blh_location.barangay_location_id
WHERE date(blhfeedback.Login_info_Open)=date(date_sub(now(),interval 0 day))
AND blhfeedback.LearningHub_LogIn='Bagong Silang'
Use IFNULL() on ‘Active Facility?’
2