I haven’t done a JOIN query in a long time, so I’m pretty rusty. What I have: a table called triggers and users. Initially, I just had a query that selected all of the information from the triggers table. This includes a user_id. Well, instead of just showing a user_id, I thought it would make sen…
Tag: join
PostgreSQL multiple join
I would like to make multiple joins in one query, I have four tables for that with the following structure: Table 1 fields, t1: did (int), finished (datetime), userid (int) Table 2 fields, t2: userid …
How to get the count of 2 values in the same column, in the same table?
I have a dataset about chess games, and in the winner column there are only 2 values: ‘white’ and ‘black’. I want to show COUNT(winner) as WHITE_WINS and COUNT(winner) as BLACK_WINS. I tried inner joining the table by itself, however couldn’t get the correct SQL query to do the j…
SQL join and Bring in 1 column into 2 columns
I have two tables shown as above. I want to create a select statement that would have the following result: Basically, I want to join on ‘Model’ and ‘Num’ columns and bring ‘Val’ vales but break it …
I can’t get around INNER JOIN in MySQL
I have two tables in my database. One of which is a table called players and the other one is bans: What I need to do is: select players that where reason = cheating and Score < 250. I tried doing some JOINS when I tried FULL JOIN I found that thing doesn’t exist in MySQL so any help would
Select unmatched records from two tables with a filter on second table
I have 2 mysql tables a and b. I need to show all records in a that are not in b using a common column ‘ID’. Normally this is pretty straight forward but my problem here is this: I need to put a where clause on table b because I’m not interested in all unmatched records just the ones that
SQLite3, Combine multiple rows in one
I have two tables cities (as C) and routes (as R) C: ____ ______ | id | city | |____|______| | 1 | A | | 2 | B | |____|______| R: ____ ______ ____ __________ | id | from | to | distance |…
Pairing table query
I was wondering how I construct a query to get all articles with all their information, and for every article a list with their tags. I used a pairing table called ArticleTags to connect Article and Tags. Can anyone tell me what the query would be if I wanted to receive all articles along with their tags per …
Create query to get count of uncompleted calls
There is table waiter_log as Call with call-id ‘f27de4f’ started in 9010 and finished in 9003 because there is a record with proceed_wait = 0 for call-id=’f27de4f’ Call with call-id ‘asdf231′ started in 9010, still proceed in 9002 and not finished yet because there is no re…
Incorrect syntax near the keyword ‘right’
i am very new to SQL, spent hours searching but all the articles point to more or less same Bellow is my code, but honestly not sure what am i doing wrong here. I want to join both tables via ID, keep the id from left and take other parameters from right table user_private_store_items i get Incorrect syntax n…