Hi list,
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 table
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
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
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
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: selecting over various tables
Hi
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 an entry in
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 tables is a sure