[DiscordArchive] Anybody decent in SQL?
[DiscordArchive] Anybody decent in SQL?
09-26-2018, 09:24 PM
Original source
Anybody decent in SQL?
I need some help
I don't know what I am doing but I am trying to move values from two tables into the other in one query
```sql
INSERT INTO ip_forums_topics (forum_id, starter_id, last_poster_id, starter_name, last_poster_name, views)
(SELECT id FROM ip_forums_forums WHERE collab_id = ip_collab_collabs.collab_id, SELECT owner_id, owner_id, owner_name, owner_name, views FROM ip_collab_collabs);
```
like this
but it appears to not be working
if you understand what I mean above, what could be the right way to do it?
rektbyfaith
09-26-2018, 09:24 PM #1Archived author: Skarn • Posted: 2018-09-26T21:24:45.729000+00:00
Original source
Anybody decent in SQL?
I need some help
I don't know what I am doing but I am trying to move values from two tables into the other in one query
```sql
INSERT INTO ip_forums_topics (forum_id, starter_id, last_poster_id, starter_name, last_poster_name, views)
(SELECT id FROM ip_forums_forums WHERE collab_id = ip_collab_collabs.collab_id, SELECT owner_id, owner_id, owner_name, owner_name, views FROM ip_collab_collabs);
```
like this
but it appears to not be working
if you understand what I mean above, what could be the right way to do it?
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)