Michael Johnson <[EMAIL PROTECTED]> wrote:
> I hope someone can help me on this. I've searched the mailing list
> archives and the manual and can't find anything, except for user comments
> in the manual that confirm what I'm finding.
>
> I'm u
4.1, derived tables, and privileges
I hope someone can help me on this. I've searched the mailing list
archives and the manual and can't find anything, except for user comments
in the manual that confirm what I'm finding.
I'm using derived tables users with restricted privil
I hope someone can help me on this. I've searched the mailing list
archives and the manual and can't find anything, except for user comments
in the manual that confirm what I'm finding.
I'm using derived tables users with restricted privileges. The only way I
can get the de
7;", because 'table' is a string, not an
object name, your subquery is returning 'table'.
You need to use dynamic sql for that sort of thing.
> -Original Message-
> From: Shawn McGinn [mailto:[EMAIL PROTECTED]
> Sent: 13 July 2003 18:02
> To: [EMAIL PRO
Are you trying to do this within a programming language? I use similar
queries using PHP and have no problem. Although I would write my query
like:
SELECT tbl_name FROM user_table WHERE user = 'guy';
And then use the result to run a select, update, insert, or whatever
-Dan
On Sun, 2003-07-13
I would like to select data from a table where the table name is located
in another table, and I am using the following query:
select t1.* from (select tbl_name from user_table where user="guy") t1;
This should return the data from table 'tbl_name', but I only get
results from the subquery (ie. t
I would like to select data from a table where the table name is located
in another table, and I am using the following query:
select t1.* from (select tbl_name from user_table where user="guy") t1;
This should return the data fom table 'tbl_name', but I only get results
from the subquery (ie. th
I am trying a query using derived tables, but have had little success.
Tables follow:
user_table
---
|user|tbl |
---
|bud |t2 |
|guy |t4 |
|abc |t5 |
---
t2
---
|a|b|c|
---
|data |
---
t4
---
|d|e|f|
---
|data |
---
etc...
I would like to