User Profile

Collapse

Profile Sidebar

Collapse
icestorm
icestorm
Last Activity: Aug 30 '06, 03:40 AM
Joined: Aug 30 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • icestorm
    replied to filter values
    in General
    oh yeah i forgot to mention 1 thing, i meant extra is null not descrip is null, and i think i have to put distinct uid and its done? (not sure if thats the correct fix but i just got it) guess i'm not thinking properly right now :P
    See more | Go to post

      Leave a comment:

    • icestorm
      started a topic filter values
      in General

      filter values

      Hi am a newbie to SQL, wasn't sure where to post this but i have this query here:

      select uid, tvalue, extra
      from interest
      where descrip is null
      order by uid;

      which has an output of

      UID TVALUE EXTRA
      111 532
      111 512
      112 532
      112 633
      112 634
      113 625

      May I know...
      See more | Go to post
      No activity results to display
      Show More
      Working...