Referencing the Table Name

07-01-2007, 7:06 PM

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

07-01-2007, 7:06 PM

"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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
key on more table	myname@yahoo.it	Database	3	07-01-2007 6:27 PM
How to take data out of table, restructure the table and then put the data back in	Laphan	Database	4	07-01-2007 6:24 PM
table output	Anthony Ritter	PHP	5	07-01-2007 5:23 PM
Delete from a table using entries in temp table	n00bie	Database	2	06-10-2007 12:25 AM
table in a table	Piotr	Database	4	06-10-2007 12:23 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)