insert using sub-query and inner join
Pradeep
i have these two tables.
The first is the users_details table
Second is the users_posts table.
i want to fill the column postedby_name with username from the first column.
I tried a combination of inner join and sub-query but could not do it.
This is the code that i have now.
update users_posts
set users_posts.postedby_name =
(select username from users_details inner join users_posts where
users_posts.postedby = users_details.id);
How to Accomplish this.?
Amit Singh
Update users_posts inner join users_details
on users_posts.postedby = users_details.id
set users_posts.postedby_name=users_details.username
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
編集
関連記事
Related 関連記事
- 1
Android: how to do an inner-join query in sqlite using the ContextResolver?
- 2
postgres insert using CTE and use the inersted id in next sub query
- 3
Django Inner Join on Derived Query
- 4
SQL query - multiple inner join
- 5
SQL QUERY Inner Join missing data
- 6
Sub query filter in LEFT/RIGHT JOIN
- 7
SQLite select query if inner join query doesn't exists
- 8
How to Delete using INNER JOIN with SQL Server?
- 9
MySQL - Using the result of a Stored Procedure in an Inner Join
- 10
Joining Multiple tables Using Inner Join MYSQL
- 11
Using Inner join and sorting records in descending order
- 12
SQL Inner Join using Distinct and Order by Desc
- 13
Mysql query inner join on most recent date (today, yesterday, or before)
- 14
Query table data with inner join and two foreing keys
- 15
Avoiding hash-join with IN clause and sub-query in Spanner
- 16
SQL Query Update using a join
- 17
How to write a SQL query that subtracts INNER JOIN results from LEFT JOIN results?
- 18
How to count number of rows in other tables using mysql inner join?
- 19
Are indeces useful when using them in combination of an INNER JOIN?
- 20
MySQLトリガーON INSERT + INNER JOIN構文エラー
- 21
SQLAlchemy: Using delete/update with a join query
- 22
Laravel 4.2 Eloquent using lists() with a join query
- 23
Create a double join query using Rails Admin
- 24
Laravel join query using Laravel eloquent
- 25
How to make insert query using SQLiteCommand?
- 26
How Do create insert query using procedure
- 27
HQL Hibernate INNER JOIN
- 28
Hibernate INNER JOIN ManyToOne
- 29
INNER JOIN ON vsWHERE句
コメントを追加