RE: SQL Problem
Try:
select a.column
from table a, outer abc b
where a.col_name != b.col_name;Notice the 'outer'.
This says that if you don't find a row in table b select the row from
table a anyway.
} -----Original Message-----
} From: PRAVEEN MOHANAN [SMTP:praveen_mohanan@hotmail.com]
} Sent: Friday, December 12, 1997 1:21 PM
} To: informix-list@rmy.emory.edu
} Subject: SQL Problem
}
}
}
} Hi folks,
}
} There is a small sql problem I faced.
}
} I created a table with one column
} create table abc
} (
} col_name varchar(8) NOT NULL
} );
}
} After this I didn't do any kind of transaction against this table.
} So, my next sql statement was
} select a.column
} from table a, abc b
} where a.col_name != b.col_name;
}
} This didn't give any result.
} So i changed this to :
} select a.column
} from table a, abc b
} where a.col_name = b.col_name;
} And Lo!! no results....!!!!!!!
} Finally i inserted a space in the table abc.
} And both the sql's started working.
}
}
} ANY COMMENTS....
}
} REgards
}
} Praveen
} Sunnyvale, CA
} e-mail praveen_mohanan@hotmail.com
} tel no : 650.594.9899 X 217
}
}
} ______________________________________________________
} Get Your Private, Free Email at http://www.hotmail.com