12 questions
0
votes
0
answers
26
views
How to fill 2 separate columns with only the most recent data associated with data
In a database that I'm creating, I need to match parent contact information with kids that are given to me in a list format. I'm matching student ID numbers with parent emails as primary keys and ...
0
votes
0
answers
69
views
I want to INSERT the user_Id from a table into the parent_id in another table however I have no common values between the two tables
I currently have three tables
users table // Data is inserted at time of sign up
usersId //PRIMARY KEY
userfName
userlName
userUid
email
userPwd
dateTime
parent table
id //PRIMARY KEY
mFname
mLname
...
0
votes
0
answers
45
views
Problems coding an Inner join update query for 2 large Access tables in different databases
For this job I'm working in VB.net front-end with back-end MS Access 2019. The issue: There are two separate Access databases each with a large table. OrigTable is where the update qry needs to put ...
- 3
1
vote
1
answer
748
views
C# LINQ join to tables and the use foreach to update one of them
I have the unenviable task of working through a large legacy C# app and finding any embedded SQL that has cross-databases references in it. We're changing the security so that any connection only has ...
- 578
0
votes
1
answer
42
views
MySQL UPDATE Two Tables with Differences From The First
I have two tables table1 and master. Master is the master database of contacts. Table1 contains recent contact information from a survey of respondents in a study.
table1 contains current ...
- 547
0
votes
1
answer
445
views
UPDATE with INNER JOIN phpmyadmin
UPDATE icmsc100 SET codigo='test'
FROM icmsc100
INNER JOIN icms307
ON icms307.ajusteDeCodigo = icmsc100.codigoItem;
I'm trying to use it this way, but it's returning an error, how should it be done?
...
1
vote
1
answer
519
views
How to update a single row from multiple rows with UPDATE JOIN
I am trying to use an UPDATE JOIN in SQL Server 2016 to update a single row from multiple rows.
I have a table with a bunch of audit events that looks like:
Event_Date,Event_Name,Entity_ID
2020-01-01,'...
-1
votes
2
answers
328
views
update with join sql | error: ORA-00933: SQL command not properly ended
i have to lower the price with 2% for each item where the capacity is more than 200 pcs using two tables where the id's have to be the same and i can not pass this error: ORA-00933: SQL command not ...
- 11
0
votes
1
answer
143
views
SQL UPDATE - INNER JOIN QUERY
I am trying to do an update in 2 tables, but i have this error:
Error SQL: ORA-00933: "SQL command not properly ended".
Could you help me please? The query is:
UPDATE a
SET a.ACTORID_ = SUBSTR(a....
0
votes
1
answer
2k
views
Update inner join data
As brought forwarded from the previous question here.
I am using the DTO method to inner join data. Now is it possible to update data at my joined result? How the data will be updated back to the ...
- 556
0
votes
1
answer
83
views
PostgreSQL UPDATE JOIN ... How does it work?
I'm having trouble understanding UPDATE with some sort of JOIN in PostgreSQL
I have the following table (names), sometimes a synonym is filled in the 3rd column:
id,name,synm,sd
41,xgvf
24,y4tg
32,...
- 413
3
votes
2
answers
139
views
Find and Replace using Update Statement via Inner Join in MySQL
I'm having two tables namely ds_message and ds_params, the first table contains the template and the second tables contains the key value pair
Table Structure: ds_message
...
- 4,933