home
I have three tables: student: sub: marks: id | name id | sub stud_id...
Thanks first. I have this right join worked fine, but when I try to change it into a left join I...
I have a MySQL db to store some equipment IP address, vendors and service status with the following...
I'm trying to gather "followers" for a specific user (#1 in this code). I'm doing my primary...
I have 2 table (A and B). Each row on table A have up to 3 correspondence on table B. Table B...
I have two table like...
I have been trying to change my old style of SQL from cross to joins, but I can't manage to make it...
I want to convert this SQL code to LINQ. Here is my SQL code: SELECT Rooms.RoomName AS RoomNo,...
i have this query: SELECT a.nombre, a.apellidos, p.nombre AS prueba, IF(r.puntuacion IS NULL, 0,...
I have a problem, I feel like I know this but I cannot find a solution. I have a temp table where...
I have two tables: Restaurants and SurveyInvitation. One restaurants has many survey...
I am getting a syntax error with the following problem and can't seem to figure out, hope you guys...
I have a database structure (ER diagram below) that has three level of hierarchical data and the...
Working on an API and I have this query: $query = CallerIdentity::findNonGeo()->join( 'RIGHT...
Hi I have issue with matching two data sets in SPARK SQL 1.6.1. I need to match (join) two...
I have a big trouble to find a correct way to select a column from another table, and show one...
I need help from captain obvious I suppose. I'm trying to Insert data from a table into a...
I have two sets of data: trainedOfficers and officersToTrain. These data sets share a ClubId in...
I have what appears to be a simple query, but is alluding my boolean challenged mind (not enough...
How does one do the following query using typeorm please SELECT * FROM "UserStrength" RIGHT JOIN...
need to combine group-by and right-outer-join. TableA has groups "a", "b", "c", "d" ...
Below I have an MySQL database where "id" is just an id for each row. "question" shows the id of...
SELECT `acart`.`order_number` AS `admin_order_number`, `acart`.`user_id` AS...
How can I perform a right join ? I'm trying to use the DefaultIfEmpty() function, but without...
assuming these 3 tables: student - | student_id | name | sex | - 31 students score - |...
I want to use inner join and right join statement. This is the relation of my tables. I'm trying...
SELECT customer_id, payment, SUM(payment) FROM telemon_payments_data payments LEFT...
I'm excercising on this open dataset. The basic description of used dataframes: There's one that...
How can I make postgreSQL query like this: SELECT event_id, user_id FROM public."point" WHERE...
I have two tables products table and batch table. products table contains a list of products and...