Join two dataset with count from another table
SELECT `A`.*,(Select COUNT(*) from `B` WHERE `peoplesoft_india_attrition`.`OU`=`B`.`OU` and `A`.`Job Code`=`B`.`Job Code` and `A`.`Date`=`B`.`LAST_DATE_WORKED` and `B`.`Separation Category`='Voluntary') As Voluntary_Count from `A`
Hi All,
I am trying to join two dataset keeping one intact and from another based on row data i am trying to pull the count. So there are couple of condition in the first database that it needs to meet to then go and use the same against another table and get the count. I am not able to get the right output here. i want to populate more columns here as well later post voluntary.
can anyone help?
0
Comments
-
What tables are A and B?
Try something closer to this I think. This will likely still need some corrections, based on your situation.
SELECT
a.*
,COUNT(b.*) as voluntary_count
FROM
a LEFT JOIN b on
a.`OU` = b.`OU`
and a.`Job Code` = b.`Job Code`
and a.`Date`= b.`LAST_DATE_WORKED`
and b.`Separation Category` = 'Voluntary'
GROUP BY
a.*Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive