Create a Table from a SQL Query with Hibernate

Question

I have 3 tables that I want to join in a single table collaborator with this Sql query :

select * from (
select user.id, Project.id, Task.id
inner join Project on user.join_key = Project.join_key
inner join  Task  on task.join_key = = Project.join_key
) collaborator

And I can't seem to find How to. I can use this also :

CREATE TABLE Collaborator AS
SELECT user.id, Project.id, Task.id
FROM Project p, Task t, User u
inner join Project on user.join_key = Project.join_key
inner join  Task  on task.join_key = = Project.join_key.

Any help would be appreciated. Thanks

Christian · Accepted Answer · 2016-08-13 14:17:26Z

1

First create the table

Collaborator

CREATE TABLE `Collaborator` (
  `USER_id` int(11),
 `PROJECT_id` int(11),
 `TASK_id` int(11)
) ENGINE=InnoDB

And then excecute the insert

INSERT INTO Collaborator 
SELECT user.id, Project.id, Task.id
FROM Project p, Task t, User u
inner join Project on user.join_key = Project.join_key
inner join  Task  on task.join_key = = Project.join_key

answered Aug 13, 2016 at 14:17

Christian

8276 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matt Over a year ago

the only thing I would suggest is to explicitly identify columns on insert the lazy style like this can lead to issues when/if columns change on the table or in the select. INSERT INTO Collaborator (User_id, Project_id, Task_id)

Collectives™ on Stack Overflow

Create a Table from a SQL Query with Hibernate

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related