You can't just with SQL, but you won't know if it is empty until you query
against it. My guess is that you need to perform some sort of join, most
likely an outer join, but an example would be helpful.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"F.G." <figor_at_iname.com> wrote in message
news:8f6ib4$dad$1_at_talia.mad.ttd.net...
> Hello,
>
> I have a query that uses a table that it can be empty, and then return me
0
> rows.
> How I can write a sql query to ignore that table in "FROM".
>
> Thanks,
>
> F.Gallego
> figor_at_iname.com
>
> PD: Excuse me , my bad english.
>
>
Received on Mon May 08 2000 - 00:00:00 CDT
