User Profile

Collapse

Profile Sidebar

Collapse
tc3driver
tc3driver
Last Activity: Nov 4 '09, 11:31 PM
Joined: Nov 3 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • tc3driver
    replied to Join same column with different data.
    in MySQL
    `ObjectCustomFi eldValues`.`Con tent` as `sev`,
    `ObjectCustomFi eldValues`.`Con tent` as `tt`


    So the return value of this query looks somewhat like this:

    EffectiveId, 'Subject', Created, OldValue, NewValue, Tcreated, sev, tt
    33544, 'Flapping.', '2009-08-02 22:19:18', 'new', 'open', '2009-08-02 22:34:35', 'Problem', 'Problem'
    33544, 'Flapping.', '2009-08-02 22:19:18', 'new', 'open', '2009-08-02 22:34:35',...
    See more | Go to post

      Leave a comment:

    • tc3driver
      started a topic Join same column with different data.
      in MySQL

      Join same column with different data.

      Hello Folks,

      I have an interesting problem, let me start off with, this database is not of my design, is an absolute mess, and there is nothing I can do about it.

      Code:
      SELECT distinct(`Tickets`.`EffectiveId`), `Tickets`.`Subject`, `Tickets`.`Created`, `Transactions`.`OldValue`,
`Transactions`.`NewValue`, `Transactions`.`Created` as `Tcreated`,
`ObjectCustomFieldValues`.`Content` as `sev`,
`ObjectCustomFieldValues`.`Content`
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...