User Profile

Collapse

Profile Sidebar

Collapse
mdaniels3423
mdaniels3423
Last Activity: Feb 5 '08, 03:01 PM
Joined: Feb 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • mdaniels3423
    replied to Complex MS SQL Query help
    okay,

    Not sure that this will work. I may need to explain a little better.

    I am trying to generate a report/query that will show me all of the errors on a per client per set level for the data range.

    the table are ordered as follows
    T1 (List of all events for all clients both normal and non-normal events)
    Fields
    Client_ID Event_ID SET_ID SET_NAME EV_TIME

    T2 (Information...
    See more | Go to post

    Leave a comment:


  • mdaniels3423
    started a topic Complex MS SQL Query help

    Complex MS SQL Query help

    Hi,

    I am new to queries, and I may be making this more difficult than necessary, but here is what I am trying to do.

    I am trying to query a DB, and returen information from several tables as follows:
    I have been able to get the query to work so far, but now I need to go a little deeper, adn I am stumped.

    so far I have the following.
    Tables = 3 (need to query 4 I think) T1, T2, T3
    ...
    See more | Go to post
No activity results to display
Show More
Working...