Re: SELECT * FROM allofthetables

[Paul DuBois]

At 9:09 PM -0500 9/8/01, Deryck Henson wrote:
>How do I select all of the tables in a database and use a whre clause like
>this??::
>
>SELECT * FROM alltables(substitute with command) WHERE User = 'username'

You can't.

>
>I need this for my site (Code Cafe- Free source code) so that the user can
>see all the code he has uploaded.  It is done in ASP, but all I need is the
>sql query string.  Thanx
>
>- Deryck H
>- http://www.comp-u-exchange.com


-- 
Paul DuBois, paul@stripped