I have a query (PostgreSQL 15.4) like this: Select p."prodId", p."prodDesc", p."areaName", x."location1" as "Location" From ops."Products" p Inner Join ops."Locations" x on p."prodId" = x."prodId" and p."areaName" = x."areaName1" Here's the caveat: in the table Locations, there are three…
I have 2 tables: book_users and assign_book_users. they look like the image below respectively. id book_id user_id status 1 11 33 open 2 44 54 closed 3 11 98 pending 4 12 33 open 5 23 99 open 6 24…
I want to join columns from several tables. For one table join works fine select org.catalog_truck.plate_number as "Госномер грузовика", shift_id as "ID смены", trip_id as "ID рейса", * from core.monitoring_stages join org.catalog_truck on vehicle_id = org.catalog_truck.catalog_truck_id where gen_id = (SELECT…
DBMS: PostgreSql, but MySql is acceptable as well I have 4 tables, permissions id slug allowed 1 create true 2 edit true 3 delete true 4 edit false roles id slug 1 Admin 2 Manger 3 User model_permissions model_type model_id…
My problem is how to make the MySQL optimizer use a composite index in the most effective way. I am using MySQL Server 8 and have a MyISAM table containing daily statistics for 'cell' objects for a period of 2…
I tried to return some of the rows in table service: SELECT ps.post_name as post, c.cname, p.place, s.date_from, s.date_to, e.emp_name as employee, s.court, s.place FROM `service` s INNER JOIN `employee` e ON s.empno = e.empno INNER JOIN `posts` ps ON…
I have two tables T1 and T2. I'm doing a simple inner join select t1.a, t1.b, t1.c from T1 t1 inner join T2 t2 on t1.c = t2.c Table T1 has got 2 million rows and T2 has got 4…
Please help with self join inside one table by different fields. given table "Items": Used PostgreSQL. I need to get all the values from such table, for which factId = 'urn:fact:drug:170' and factId1 ='urn:fact:drug:171' and factId1.value ='false' and arrayIndexes are…
In MySQL, I have a myTab1 which has columns like userId, name, gender, birthMonth. Here userId is the primary key. There can be only 1 unique userId in the entire table. I have another table myTab2 which has columns like…
I am joining two tables with the student table using the inner join below: select (first_name || ' ' ||last_name) as "Student Name", gender, race from student inner join gender on student.gender_id = gender.gender_id inner join race on student.race_id =…