: Wednesday, November 1, 2006 4:51:21 PM GMT-0500 US/Eastern
Subject: Re: Manually Inserted Data
Keith Spiller wrote:
Hi Rolando,
Thanks for your help.
I have reduced the query to the bare essensials to try to test the
concept, but
it still fails...
( SELECT ID, Start, End
( SELECT ID, Start
Hi,
I'm trying to manually insert data into a mysql query so that the
data will be sorted by the query but not inserted into the table.
Here's what I have so far:
( SELECT ID, Title, Label, Location, Start, End, Time,
Description, Organization, Department, Contact, Phone,
Email, Global,
The first UNION part has 19 columns
the other UNION part has 18 columns
- Original Message -
From: Keith Spiller [EMAIL PROTECTED]
To: [MySQL] mysql@lists.mysql.com
Sent: Wednesday, November 1, 2006 3:31:24 PM GMT-0500 US/Eastern
Subject: Manually Inserted Data
Hi,
I'm trying
DESC, Time ASC a
Does anyone see my mistake?
Keith
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED]
To: Keith Spiller [EMAIL PROTECTED]
Cc: MySQL mysql@lists.mysql.com
Sent: Wednesday, November 01, 2006 2:11 PM
Subject: Re: Manually Inserted Data
The first UNION part has
Keith Spiller wrote:
Hi Rolando,
Thanks for your help.
I have reduced the query to the bare essensials to try to test the
concept, but
it still fails...
( SELECT ID, Start, End
( SELECT ID, Start, End as z
FROM site_calendar_v2 as c
WHERE Global='1' )
UNION
( SELECT '9', '2006-11-01',