Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zim327
Yak Posting Veteran
62 Posts |
 Posted - 2007-04-10 : 14:44:06
|
| I need to display all the completed steps of a process.I can get all the steps except for the very first step which for some strange reason is stored in a different table with different columns. the only common column is the workid. sounds simple right?I want 1 step per row, but when I do the join, the first step (step zero) is on EVERY line while steps 1 - 30 each have their own row.Here's the sql:SELECT * FROM wsubworktask, wfcomments WHERE WF_WORKFLOWID = subworktask_subworkid AND subworktask_subworkid = 10617727 AND (subworktask_status = -1 OR subworktask_status = 2) ORDER BY subworktask_status ASC, subworktask_datedone, SUBWORKTASK_TASKID DESCthanks,Best regards, Zim(Future Eternal Yak God Emperor) |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-04-10 : 18:40:54
|
| You're querry is all over the place. Please post your table structure, and desired results. Thanks |
 |
|
|
|
|
|
how do I join these tables?