WEB database select statement

Discussion in 'OT Technology' started by hurleyint1386, Dec 11, 2007.

  1. hurleyint1386

    hurleyint1386 Someone has sand in their vagina

    Joined:
    Jan 6, 2005
    Messages:
    3,687
    Likes Received:
    0
    Location:
    Rochester, NY
    I'm trying to do a select statement in oracle and I'm having some trouble. I'm trying:

    Code:
    select * from tb1 inner join tb2 on tb1.column1 = tb2.column2 where tb1.column3='';
    
    Those aren't the exact names, but same idea. I'm trying to select something where one of the fields in a column is equal to NULL or blank. I keep getting "no data found" however I know that there is something with nothing in that field
     
  2. TheDarkHorizon

    TheDarkHorizon \xC0\xFF\xEE

    Joined:
    Sep 26, 2002
    Messages:
    2,396
    Likes Received:
    0
    Location:
    San Francisco, CA
    (where tb1.column3='' or tb1.column3 IS NULL)
     

Share This Page