sql - Can Cross join and in can be same query? -

i trying club 2 tables using cross join below

select * nasda_objects   cross join (select * nasda_objects); 

and same working

but when try use in in left table of cross join not working

select * nasda_objects co_gid in (450,550,650)   cross join (select * nasda_objects); 

so in , cross join in same query not supported ?

try this;

select * nasda_objects cross join (select * nasda_objects) co_gid in (450,550,650); 

ie, need add where condition @ last when have joined tables.