Referencing the Table Name

[Dan J.]

Say I have a Table called Predator: country(varchar 20),
animal(varchar 20)

And I want to search for the animal "Python" in my Predator table, but
if it is present, I want
to simply reference the name of the table...so "Predator" would
return. I am sure this is really
simple, but I have looked and looked with no luck.

Thank You Very Much,
Dan

[Bill Karwin]

"Dan J." <spwpreston@gmail.com> wrote in message
news:1141461706.226104.4060@i39g2000cwa.googlegrou ps.com...

> And I want to search for the animal "Python" in my Predator table, but
> if it is present, I want to simply reference the name of the table...so
> "Predator" would
> return.

SELECT DISTINCT 'Predator'
FROM Predator
WHERE animal = 'Python'

Regards,
Bill K.