SQL & PL/SQL

Hi,

I am querying the dba_tab_columns to crosscheck a table name which contains the specified column in the given query. the query is...

select a.table_name
from dba_tab_columns a, dba_tab_columns b
where
b.column_name = 'NAME_ID'
and
b.column_name = 'GUEST_FIRST_NAME'
and
a.column_id = b.column_id

I know both name_id and first_guest_name column present in a table called resev_name, but it return no rows selected. may be, I am msiising something.

hare krisha
Alok