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. Thanks for the solution. But my question is then what does the column in the table abc contain when the table is created, if not NULL or space. (Refer below) Regards Praveen } } } } 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 ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com