mysqlnavicat
navicat select number of entries in one table as value in query builder
I have a current Navicat Query Builder as follows:
I want to select to select the number of records from another table that will be linked to the scoring_sections table as "num_entries" in the output results.
The table that I will be linking looks like this:
I cannot seem to figure this out as this is my first time working with navicat and couldn't find anything on Google
Thanx in advance
Solution
I had to group_by all the columns from the scoring_sections that are linked to the entries table and just added COUNT(entries.id) AS num_entries in the select statement. so used MYSQL knowledge to complete this
- MySQL or MariaDB - how to instantiate user @variables?
- MySQLConnector c# update MySqlCommand parameters
- INSERT INTO after WITH statement in MySQL
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
- Connect to mysql in a docker container from the host
- Executing SQL scripts on docker container
- XAMPP - Error: MySQL shutdown unexpectedly
- Undefined Module Mysl - Ballerina
- DBeaver error resolving maven dependencies
- ERROR - Must Declare Scalar Variable - C#
- Cannot delete or update a parent row: a foreign key constraint fails. Foreign keys exist though
- MySQL: IF EXISTS ... TRUNCATE
- mysql COUNT and Sum with join 2 tables
- Install Navicat on Linux Ubuntu 12.04
- How do I set MySQL temporarily to read-only through the command line?
- How to increment column values with CodeIgniter's update_batch()
- str_to_date is showing NULL when date is available
- Can I use a variable from the GET_ method to fetch MySQL data?
- select ... where id = any value. is it possible?
- Data truncated for column?
- Unable to install MySQL on Windows 10 - Installer hangs indefinitely
- Why can't I just use "HAVING" clause all the time instead of "WHERE"? It works the same basically if you use it before/without "GROUP BY"
- MySQL Workbench: Connecting to database automatically on the startup
- Select rows for a specific date using TIMESTAMP datatype
- GoLang How to load nested objects using GORM
- What COLLATE should i set to use all kind of possible languages?
- MYSQL - SELECT NULL otherwise latest DATE per group
- How do I set up replication from MySQL to MongoDB?
- NULL when value not found using substring_index in MYSQL
- How to convert an entire MySQL database characterset and collation to UTF-8?