a_elnajjar — 2012-05-17T22:16:09-04:00 — #1
I just want to ask if I got my T-SQL right? I write a statement to get all task and project for login user
SELECT Users.userName, Tasks.taskName, Tasks.priority AS TaskPriority, Tasks.createdOn AS TaskcreatedOn, Tasks.estTime, Projects.projectName, Tasks.taskID, Users.userID, Projects.projectID
FROM Users INNER JOIN Users_projects AS usp ON usp.userID = Users.userID
INNER JOIN Projects ON usp.projectID = Projects.projectID
INNER JOIN Projects_tasks ON Projects.projectID = Projects_tasks.projectID
INNER JOIN Tasks ON Projects_tasks.taskID = Tasks.taskID
r937 — 2012-05-17T22:25:51-04:00 — #2
what happened when you tested it?
a_elnajjar — 2012-05-17T22:41:17-04:00 — #3
it run without any problem but just I want to make sure I get right and to see if their are more way to optimize it ?
mittineague — 2014-09-23T03:36:19-04:00 — #4
This topic is now archived. It is frozen and cannot be changed in any way.