I have a bit of a complicated scenario. I have two tables, employee and agency. An employee may or may not have an agency, but if an employee has an agency I want the select clause to check another condition…
I'm trying to join 2 tables and count the number of entries for unique variables in one of the columns. In this case I'm trying to join 2 tables - patients and trials (patients has a FK to trials) and…
I am trying to get the result of games where records are not in team_id array. from front end, sending array of team_id [ 23, 24 ], the result should not consider 23, 24 id from game_teams table games table…
Here is the issue to solve. I have a table USERS and a table GROUP_USER. I am updating table USERS and the data I update in that table will directly affect the GROUP_USER table. Here are the tables **Users table**…
Via SQL, I'm trying to get from this: id group_id session_id field_label field_value sent_at 1 frosted flakes blue bowl first_name Bob 2022-11-05 18:18:19.093 2 frosted flakes blue bowl first_name Bobby 2022-11-05 18:17:31.274 3 frosted flakes blue bowl last_name Brown 2022-11-05…
In the following case: CREATE TABLE Persons ( groupId int, age int, Person varchar(255) ); insert into Persons (Person, groupId, age) values('Bob' , 1 , 32); insert into Persons (Person, groupId, age) values('Jill' , 1 , 34); insert into Persons…
Schema Details We are maintaining collections data in a project. Main columns of Collections table are id(INT), collectionId(String UUID), versionNo(INT), status(PUBLISHED/NEW/PURCHASED/DELETED/ARCHIVED). Each collection can have several versions. For each different version, versionNo, id, status column will have different values but…
I have tables like this: Table_0 CustomerID Trans_date C001 01-sep-22 C001 04-sep-22 C001 14-sep-22 C002 03-sep-22 C002 01-sep-22 Table_1 CustomerID Trans_date C002 18-sep-22 C002 20-sep-22 C003 02-sep-22 C003 28-sep-22 Table_2 CustomerID Trans_date C004 08-sep-22 C004 18-sep-22 C004 20-sep-22 C005 18-sep-22…
Very new to coding. I have 2 tables, zips_usa which includes all properly formatted zips (zipcode, lat / lon / city / state etc) in the US, and table ageus which includes columns such as first name, last name, category,…
Why must I state the table I'm referring to TWICE when using a join on a query? select table1.name from table1 inner join table2 on etc ...