Given that I have these two following tables: level_table id level_date level 300 2021-05 C 300 2020-04 C 300 2019-08 C 300 2022-06 C 300 2019-02 C 300 2018-01 C 300 2023-05 C 300 2021-11 C 300 2021-09 C 300…
I run into this situation from time to time, where I want to take a list of things and see if any of them exist in another list. If you have a single number, it's simple enough to use a…
We have a table "url_rewrite" in our Magento 2 store and we need to copy a lot of values inside this table. We have a column "store_id", that contains values from 1 until 4. Another column with "target_path" and the…
I have a table Assets table Asset Id | Asset Name | Asset Type | Product Id Transfers Table Transfer Id | From Asset ID | To Asset Id | Product Id I'm trying to join these table to get…
I have two tables, one named user and the other named payment. A user can have multiple payments. example: user 1 with 2 payments user 2 with 5 payments user 3 with 10 payments user 4 with 7 payments I…
Table "ORDER": ID ORDERN_NUM 1 123 2 321 3 456 Table "RECEIVERS": FIRST_NAME ID LAST_NAME Pete 1 Tyler Sarah 1 Bowden Bart 2 Simpson Table "PRODUCTS": TYPE ID Towel 1 Pen 1 Spoon 2 We can say "FIRST_NAME" and "TYPE"…
We are trying to get filtered custom field data out of the Moodle database via SQL query. Unfortunately it's necessary to join multiple tables to get the data we need, because Moodle keeps its data this way. Also we can't…
MySQL / MariaDB structure: Person | id | |----| | 1 | | 2 | | 3 | Car | person_id | car | |-----------|-------| | 1 | Ford | | 2 | Mazda | | 3 | Ford |…
I need a sql query to print the count of records from different table for particular column. I have tried the below but it is not working. SELECT t1.names, COUNT(t1.name) as Table1 count, COUNT(t2.FILENAME) as Table2 count FROM Table1 t1…
There are 3 tables, A, B, C. Table A has an id column, and B & C integer column which represents money and a_id which reference id in table A. Below is an example of table A, B, C table…