At 15:52 28.01.02 +0100, you wrote:
> > Your suggestion might work but I'm not sure if it's fast enough to be
> > done "on-the-fly" (i.e. during a http user request) due to the fact that
> > the tables are quite large and I have to "manually join" 10 tables :(
>
>I'd say that a UNION over 10 table
On Mon, 28 Jan 2002 14:49:18 +0100
Harald Fuchs <[EMAIL PROTECTED]> wrote:
> In article <[EMAIL PROTECTED]>,
> "Tobias Kremer :: IT" <[EMAIL PROTECTED]> writes:
>
> > Hi,
> > Thanx dn. I know how to build joined selects but the problem is that those
> > two tables are not joinable. I don't have
Hi Tobias,
Would the UNION command help?
(otherwise we'd need to see the table definitions to comment)
Regards,
=dn
- Original Message -
From: "Tobias Kremer :: IT" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 28 January 2002 12:34
Subject: Re: selecti
Thanx, Roger.
Harald was right: What I want to do is a UNION which is not implemented
in mysql prior 4.0.0 :((
Your suggestion might work but I'm not sure if it's fast enough to be
done "on-the-fly" (i.e. during a http user request) due to the fact that
the tables are quite large and I have to "
* Tobias Kremer :: IT
> Thanx dn. I know how to build joined selects but the problem is that those
> two tables are not joinable. I don't have an entry in table 1 which
> references to a field in table 2. I just want to create a list of
> both tables ordered by date and limited to say 20 entries.
Hi,
Thanx dn. I know how to build joined selects but the problem is that those
two tables are not joinable. I don't have an entry in table 1 which
references to a field in table 2. I just want to create a list of
both tables ordered by date and limited to say 20 entries.
At 12:22 28.01.02 +,
Hi Tobias,
Assume I have various tables which all have these three fields:
userid, title, date_created
Now I want to create a list containing entries
of all tables ordered by date_created with a single select.
Is this possible or do I have to make either various
selects or create an extra tabl
