MySQL Forums :: Table Space :: sorting by values from joined table
sorting by values from joined table
Posted by: Łukasz Korona ()
Date: September 05, 2011 01:43AM
Hello,
I have two tables. First contains info about some tasks - task id , task due time, task description and id of user assigned to this task. Second table contains user info user id , user email, user name etc.
I want to display info from both tables and be able to sort the results by columns from both tables. What kind of join i need? Do I need some kind of group or union?
Please help.
Thanks in advance.
I have two tables. First contains info about some tasks - task id , task due time, task description and id of user assigned to this task. Second table contains user info user id , user email, user name etc.
I want to display info from both tables and be able to sort the results by columns from both tables. What kind of join i need? Do I need some kind of group or union?
Please help.
Thanks in advance.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| sorting by values from joined table | 1313 | Łukasz Korona | 09/05/2011 01:43AM |
| Re: sorting by values from joined table | 556 | Rick James | 09/06/2011 07:30PM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates