Questions tagged [multi-table]
138 questions
2
votes
1 answer
how to update multiple based table from datagridview in wpf
public DataTable FillDataGrid()
{
string CmdString = string.Empty;
using (SqlCeConnection con = new SqlCeConnection(ConString))
{
CmdString = "SELECT categories.categories_id as ID, categories_description.categories_name as…
Striker
- 948
- 1
- 13
- 28
2
votes
1 answer
multi table insert fecthing value from another table
I have tables - FAKE_CUST, PRE_CUST, NORMAL_CUST. Based on the constraint present in FAKE_CUST table, the value has to be brought to either PRE_CUST or NORMAL_CUST.
I am using the follwing code:
INSERT ALL
INTO PRE_CUST(CUST_ID,…
ritika
- 61
- 1
- 10
2
votes
1 answer
Save data in relational table in content provider by inner join
How you can see in image i have a TABLE A, TABLE C e an array list A.
I need to create a relational table (Table B) that have id of Table A (id_A) and id of Table C (id_C). The array list have every id's of table C that I need. So i need a way to…
Ricardo Filipe
- 435
- 4
- 8
- 24
1
vote
1 answer
Android ormlite Multi-table mapping
I want to use ormlite in my android project, but I don't know how to solve the multi-table mapping.Some suggest?
BlackDev
- 57
- 1
- 5
1
vote
3 answers
MySQL Multi Table Search
table1
ID
SUBJECT
CONTENT
table2
ID
SUBJECT
CONTENT
table3
ID
SUBJECT
CONTENT
... 5 more
I want to search SUBJECT on all the tables
How can I do this?
Awersione
- 383
- 1
- 3
- 6
1
vote
0 answers
Codeigniter 4 sum many columns in multiple join table giving wrong results
I am doing my first project using Codeigniter 4. I am trying to make a summary page which consist of some sum from different columns and different tables.
Here is the tables :
table project
id project_name
1 project 1
2 project…
Shannaz Wakid
- 21
- 1
1
vote
0 answers
Codeigniter 4 sum many columns in multiple join table throwing wrong results
I am doing my first project using Codeigniter 4. I am trying to make a summary page which consist of some sum from different columns and different tables.
Here is the tables :
table project
id
project_name
1
project 1
2
project 2
table…
Shannaz Wakid
- 21
- 1
1
vote
0 answers
How can I perform a multi-table join and update operation in GridDB using SQL?
I have multiple containers in my GridDB database and I need to perform a join operation involving multiple tables, followed by an update operation based on the joined results. However, I'm not sure how to achieve this using GridDB's SQL…
SimoIT
- 79
- 4
1
vote
0 answers
How to retrieve and display data from multiple tables with no foreign keys using django-betterforms
I'm trying to implement the CRUD function using GenericView + ClassBaseView,
but I'm stumped on the ListView display part.
If anyone has a solution, please let me know.
I'm not very experienced with django and web apps,
and I'm not familiar with the…
Worried
- 31
- 3
1
vote
0 answers
How to create a trigger before insert in db2
I have three tables below:
I need to create a trigger to disallow students to take a class without completing their pre-requisites (must use a trigger). The trigger must return an error message "Missing Pre-req" when trying to insert a class…
David
- 33
- 4
1
vote
1 answer
Dynamic USE statement
I am looking if anyone has any reason why the code below is a bad idea.
This challenge deals with a challenge I have encountered in several different places and circumstances. How to run the same query against identical table structures in multiple…
Paul Wichtendahl
- 117
- 7
1
vote
13 answers
Without using an explicit JOIN operator make multi table sub query in SQL?
Without using an explicit JOIN operator ind the Per Capita Income of the Community Area which has a school Safety Score of 1.
SELECT per_capita_income,community_area_name
FROM CENSUS_DATA
where community_area_name =
(SELECT…
adams x
- 19
- 1
- 3
1
vote
1 answer
My SQL - COUNT field on multitable group by other field
I missed to create the correct request.
My request is :
select actionreal, sum(nb_actions) nb_actions from (
select actionreal, count(distinct departement) nb_actions
from militant_action_nutrition
where actionreal in (1, 2, 3)
group by…
Jonathan G.
- 23
- 3
1
vote
3 answers
sql server count from different table if not all rows exists
Im trying to get results from 2 tables. The first table there is the Ids with info, from the 2nd table I want to count existing for each id from the 1st table based on some condition. here is my code:
SELECT p.stId, count(att.adate)
FROM payments…
RF312
- 11
- 1
1
vote
0 answers
SUM php/mysql multi-tables
I would like to display the sums of the numbers in the columns of different tables. Tables are governed by a database join. I do not find the correct syntax to display the sums separately, it calculates everything without differentiating the arrays.…
Stéphane Donchery
- 11
- 2