I'm trying to join a new column to my current query that uses aggregate functions. I create this column with a new query that also uses an aggregate function from a different table but I'm not sure if a JOIN…
in my Laravel app I have 3 tables : users, documents and type_documents, the user have multiple documents and document have one type_document | Documents | | -------- | | id | | file | | type_document_id| | user_id |…
I am trying to update a column in the mainDB table, based on data in the engine table. The date in the main DB table is stored in (YYYY-MM_DD) format and I want to subtract only the year I'm not…
Description: We have two tables as below: table_1 ("question" main table) table_2 ("question_attempted" joining table) Cases: In "table_2" we have a column that has a column "is_correct" (holds 1,0) for right or wrong answers. In "table_1" we have 1 m…
I have to join user_name from user table where as first_name and last_names from user_profile table. Until here everything is fine, but when I try to fetch respective roles assigned from user_role tables it gives multiple rows for single user…
How can I make an SQL query to select records that do not have at least one child element? I have 3 tables: article (~40K rows), calendar (~450K rows) and calendar_cost (~500K rows). It is necessary to select such entries…
So i have table Project --------------------------------- project_id | name| --------------------------------- 1 | project 1 | 2 | project 2 | --------------------------------- table 02 report ---------------------------------------------------- report_id | report_emp | report_hours |report_project_id| --------------------------------------------------- 1 | 1 | 5 | 1 |…
I need to apply the same join i do in this code, but in another code i build it with EloquentBuilder $query The join I want is this: $afiliates = DB::table('ad_afiliado as af') ->join('af_promocion as promo', 'af.Clave', '=', 'promo.id_afiliado') ->select('af.logo_url',…
I have table towns which is main table. This table contains so many rows and it became so 'dirty' (someone inserted 5 milions rows) that I would like to get rid of unused towns. There are 3 referent table that…
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…