subquery, alias and derived tables

03/10/2007, 13h18

Hello, I am trying to come up with a way to preform the same query over a
list of tables; of which the tablenames are stored in a ... table.

I have tried numerous ways but unfortunatly the column name is not
expanded or treated as the tablename in the outerquery. So I am trying
now with a subquery only to get caught in the alias mixer. For example:

mysql> SELECT open,high,low,close FROM (SELECT tablename FROM properties);
ERROR 1248 (42000): Every derived table must have its own alias

Is there a way to receive the list of tablenames and preform a subquery
within the same select statement ?

If so I am going to keep searching for the answer using subquery
otherwise I will have to come up with something else.

Thank you for any suggestions.

Cheers,

Hans.

03/10/2007, 13h58

On 3 Oct, 13:18, hans christian <christ...@notmail.com> wrote:
> Hello, I am trying to come up with a way to preform the same query over a
> list of tables; of which the tablenames are stored in a ... table.
>
> I have tried numerous ways but unfortunatly the column name is not
> expanded or treated as the tablename in the outerquery. So I am trying
> now with a subquery only to get caught in the alias mixer. For example:
>
> mysql> SELECT open,high,low,close FROM (SELECT tablename FROM properties);
> ERROR 1248 (42000): Every derived table must have its own alias
>
> Is there a way to receive the list of tablenames and preform a subquery
> within the same select statement ?
>
> If so I am going to keep searching for the answer using subquery
> otherwise I will have to come up with something else.
>
> Thank you for any suggestions.
>
> Cheers,
>
> Hans.

I think you need a stored procedure

03/10/2007, 21h50

On Wed, 03 Oct 2007 05:58:20 -0700, Captain Paralytic wrote:

> On 3 Oct, 13:18, hans christian <christ...@notmail.com> wrote:
>> Hello, I am trying to come up with a way to preform the same query over
>> a list of tables; of which the tablenames are stored in a ... table.
>>
>> I have tried numerous ways but unfortunatly the column name is not
>> expanded or treated as the tablename in the outerquery. So I am trying
>> now with a subquery only to get caught in the alias mixer. For example:
>>
>> mysql> SELECT open,high,low,close FROM (SELECT tablename FROM
>> properties); ERROR 1248 (42000): Every derived table must have its own
>> alias
>>
>> Is there a way to receive the list of tablenames and preform a subquery
>> within the same select statement ?
>>
>> If so I am going to keep searching for the answer using subquery
>> otherwise I will have to come up with something else.
>>
>> Thank you for any suggestions.
>>
>> Cheers,
>>
>> Hans.
>
> I think you need a stored procedure

Hmmm 2 bad

Anyway thank you for your answer !

Hans.

04/10/2007, 12h44

On 3 Oct, 21:50, hans christian <christ...@notmail.com> wrote:
> On Wed, 03 Oct 2007 05:58:20 -0700, Captain Paralytic wrote:
> > On 3 Oct, 13:18, hans christian <christ...@notmail.com> wrote:
> >> Hello, I am trying to come up with a way to preform the same query over
> >> a list of tables; of which the tablenames are stored in a ... table.
>
> >> I have tried numerous ways but unfortunatly the column name is not
> >> expanded or treated as the tablename in the outerquery. So I am trying
> >> now with a subquery only to get caught in the alias mixer. For example:
>
> >> mysql> SELECT open,high,low,close FROM (SELECT tablename FROM
> >> properties); ERROR 1248 (42000): Every derived table must have its own
> >> alias
>
> >> Is there a way to receive the list of tablenames and preform a subquery
> >> within the same select statement ?
>
> >> If so I am going to keep searching for the answer using subquery
> >> otherwise I will have to come up with something else.
>
> >> Thank you for any suggestions.
>
> >> Cheers,
>
> >> Hans.
>
> > I think you need a stored procedure
>
> Hmmm 2 bad

>
> Anyway thank you for your answer !
>
> Hans.- Hide quoted text -
>
> - Show quoted text -

Why 2bad?

05/10/2007, 15h34

On Thu, 04 Oct 2007 04:44:52 -0700, Captain Paralytic wrote:

> On 3 Oct, 21:50, hans christian <christ...@notmail.com> wrote:
>> On Wed, 03 Oct 2007 05:58:20 -0700, Captain Paralytic wrote:
>> > On 3 Oct, 13:18, hans christian <christ...@notmail.com> wrote:
>> >> Hello, I am trying to come up with a way to preform the same query
>> >> over a list of tables; of which the tablenames are stored in a ...
>> >> table.
>>
>> >> I have tried numerous ways but unfortunatly the column name is not
>> >> expanded or treated as the tablename in the outerquery. So I am
>> >> trying now with a subquery only to get caught in the alias mixer.
>> >> For example:
>>
>> >> mysql> SELECT open,high,low,close FROM (SELECT tablename FROM
>> >> properties); ERROR 1248 (42000): Every derived table must have its
>> >> own alias
>>
>> >> Is there a way to receive the list of tablenames and preform a
>> >> subquery within the same select statement ?
>>
>> >> If so I am going to keep searching for the answer using subquery
>> >> otherwise I will have to come up with something else.
>>
>> >> Thank you for any suggestions.
>>
>> >> Cheers,
>>
>> >> Hans.
>>
>> > I think you need a stored procedure
>>
>> Hmmm 2 bad

>>
>> Anyway thank you for your answer !
>>
>> Hans.- Hide quoted text -
>>
>> - Show quoted text -
>
> Why 2bad?

Because I'm lazy ...

Hans.

10/10/2007, 10h52

Hello,
i have the same problem.
Did you find then answer, please?
J

12/10/2007, 10h55

On Oct 3, 1:18 pm, hans christian <christ...@notmail.com> wrote:
> Hello, I am trying to come up with a way to preform the same query over a
> list of tables; of which the tablenames are stored in a ... table.
>
> I have tried numerous ways but unfortunatly the column name is not
> expanded or treated as the tablename in the outerquery. So I am trying
> now with a subquery only to get caught in the alias mixer. For example:
>
> mysql> SELECT open,high,low,close FROM (SELECT tablename FROM properties);
> ERROR 1248 (42000): Every derived table must have its own alias
>
> Is there a way to receive the list of tablenames and preform a subquery
> within the same select statement ?
>
> If so I am going to keep searching for the answer using subquery
> otherwise I will have to come up with something else.
>
> Thank you for any suggestions.
>
> Cheers,
>
> Hans.

Hi Hans

Try this: "SELECT open,high,low,close FROM (SELECT tablename FROM
properties) as my_table; "

03/10/2007, 13h18	#1
hans christian Messages: n/a Hébergeur:	subquery, alias and derived tables Hello, I am trying to come up with a way to preform the same query over a list of tables; of which the tablenames are stored in a ... table. I have tried numerous ways but unfortunatly the column name is not expanded or treated as the tablename in the outerquery. So I am trying now with a subquery only to get caught in the alias mixer. For example: mysql> SELECT open,high,low,close FROM (SELECT tablename FROM properties); ERROR 1248 (42000): Every derived table must have its own alias Is there a way to receive the list of tablenames and preform a subquery within the same select statement ? If so I am going to keep searching for the answer using subquery otherwise I will have to come up with something else. Thank you for any suggestions. Cheers, Hans.

03/10/2007, 13h58	#2
Captain Paralytic Messages: n/a Hébergeur:	Re: subquery, alias and derived tables On 3 Oct, 13:18, hans christian <christ...@notmail.com> wrote: > Hello, I am trying to come up with a way to preform the same query over a > list of tables; of which the tablenames are stored in a ... table. > > I have tried numerous ways but unfortunatly the column name is not > expanded or treated as the tablename in the outerquery. So I am trying > now with a subquery only to get caught in the alias mixer. For example: > > mysql> SELECT open,high,low,close FROM (SELECT tablename FROM properties); > ERROR 1248 (42000): Every derived table must have its own alias > > Is there a way to receive the list of tablenames and preform a subquery > within the same select statement ? > > If so I am going to keep searching for the answer using subquery > otherwise I will have to come up with something else. > > Thank you for any suggestions. > > Cheers, > > Hans. I think you need a stored procedure

03/10/2007, 21h50	#3
hans christian Messages: n/a Hébergeur:	Re: subquery, alias and derived tables On Wed, 03 Oct 2007 05:58:20 -0700, Captain Paralytic wrote: > On 3 Oct, 13:18, hans christian <christ...@notmail.com> wrote: >> Hello, I am trying to come up with a way to preform the same query over >> a list of tables; of which the tablenames are stored in a ... table. >> >> I have tried numerous ways but unfortunatly the column name is not >> expanded or treated as the tablename in the outerquery. So I am trying >> now with a subquery only to get caught in the alias mixer. For example: >> >> mysql> SELECT open,high,low,close FROM (SELECT tablename FROM >> properties); ERROR 1248 (42000): Every derived table must have its own >> alias >> >> Is there a way to receive the list of tablenames and preform a subquery >> within the same select statement ? >> >> If so I am going to keep searching for the answer using subquery >> otherwise I will have to come up with something else. >> >> Thank you for any suggestions. >> >> Cheers, >> >> Hans. > > I think you need a stored procedure Hmmm 2 bad Anyway thank you for your answer ! Hans.

04/10/2007, 12h44	#4
Captain Paralytic Messages: n/a Hébergeur:	Re: subquery, alias and derived tables On 3 Oct, 21:50, hans christian <christ...@notmail.com> wrote: > On Wed, 03 Oct 2007 05:58:20 -0700, Captain Paralytic wrote: > > On 3 Oct, 13:18, hans christian <christ...@notmail.com> wrote: > >> Hello, I am trying to come up with a way to preform the same query over > >> a list of tables; of which the tablenames are stored in a ... table. > > >> I have tried numerous ways but unfortunatly the column name is not > >> expanded or treated as the tablename in the outerquery. So I am trying > >> now with a subquery only to get caught in the alias mixer. For example: > > >> mysql> SELECT open,high,low,close FROM (SELECT tablename FROM > >> properties); ERROR 1248 (42000): Every derived table must have its own > >> alias > > >> Is there a way to receive the list of tablenames and preform a subquery > >> within the same select statement ? > > >> If so I am going to keep searching for the answer using subquery > >> otherwise I will have to come up with something else. > > >> Thank you for any suggestions. > > >> Cheers, > > >> Hans. > > > I think you need a stored procedure > > Hmmm 2 bad > > Anyway thank you for your answer ! > > Hans.- Hide quoted text - > > - Show quoted text - Why 2bad?

05/10/2007, 15h34	#5
hans christian Messages: n/a Hébergeur:	Re: subquery, alias and derived tables On Thu, 04 Oct 2007 04:44:52 -0700, Captain Paralytic wrote: > On 3 Oct, 21:50, hans christian <christ...@notmail.com> wrote: >> On Wed, 03 Oct 2007 05:58:20 -0700, Captain Paralytic wrote: >> > On 3 Oct, 13:18, hans christian <christ...@notmail.com> wrote: >> >> Hello, I am trying to come up with a way to preform the same query >> >> over a list of tables; of which the tablenames are stored in a ... >> >> table. >> >> >> I have tried numerous ways but unfortunatly the column name is not >> >> expanded or treated as the tablename in the outerquery. So I am >> >> trying now with a subquery only to get caught in the alias mixer. >> >> For example: >> >> >> mysql> SELECT open,high,low,close FROM (SELECT tablename FROM >> >> properties); ERROR 1248 (42000): Every derived table must have its >> >> own alias >> >> >> Is there a way to receive the list of tablenames and preform a >> >> subquery within the same select statement ? >> >> >> If so I am going to keep searching for the answer using subquery >> >> otherwise I will have to come up with something else. >> >> >> Thank you for any suggestions. >> >> >> Cheers, >> >> >> Hans. >> >> > I think you need a stored procedure >> >> Hmmm 2 bad >> >> Anyway thank you for your answer ! >> >> Hans.- Hide quoted text - >> >> - Show quoted text - > > Why 2bad? Because I'm lazy ... Hans.

10/10/2007, 10h52	#6
jcwebb@dicoe.com Messages: n/a Hébergeur:	Re: subquery, alias and derived tables Hello, i have the same problem. Did you find then answer, please? J

12/10/2007, 10h55	#7
bamroberts@gmail.com Messages: n/a Hébergeur:	Re: subquery, alias and derived tables On Oct 3, 1:18 pm, hans christian <christ...@notmail.com> wrote: > Hello, I am trying to come up with a way to preform the same query over a > list of tables; of which the tablenames are stored in a ... table. > > I have tried numerous ways but unfortunatly the column name is not > expanded or treated as the tablename in the outerquery. So I am trying > now with a subquery only to get caught in the alias mixer. For example: > > mysql> SELECT open,high,low,close FROM (SELECT tablename FROM properties); > ERROR 1248 (42000): Every derived table must have its own alias > > Is there a way to receive the list of tablenames and preform a subquery > within the same select statement ? > > If so I am going to keep searching for the answer using subquery > otherwise I will have to come up with something else. > > Thank you for any suggestions. > > Cheers, > > Hans. Hi Hans Try this: "SELECT open,high,low,close FROM (SELECT tablename FROM properties) as my_table; "

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email