Hi,
On Jan 18, 2008 2:59 PM, RoryGRen <[EMAIL PROTECTED]> wrote:
>
> Hi all
>
> I am quite new to mySQL and have the following question I hope someone can
> help me with:
>
> I have a database table imported directly from MS Access with two of the
> field names having brackets - F(1) and S(1). I d
At 21:21 -0700 9/21/02, Des Dougan wrote:
>I want to extract data into a temporary table such that unique
>records with the same primary key (in this case an invoice number)
>are written to one record, with each of the unique fields extracted
>being written to a separate field in the temporary
suggested in your previous post.
Thanks,
- Tom Jones
[EMAIL PROTECTED]
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: "Tom Jones" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 12, 2002 15:35
Subject:
On Sat, 12 Jan 2002, Tom Jones wrote:
> >Table: flights
> >Fields: depart, depart_time, arrive, arrive_time, flight_no, flight_group
>
> I'm trying to do a search on "depart" and "arrive" and show only the records
> which have matching "flight_group"
SELECT depart, arrive
FROM flights
WHERE
> Hello,
> I've been trying to figure this out but I feel like I'm just
> banging my head
> on the wall.
That must be quite painful...
> I hope this is the right forum to pose this question.
It's certainly one of the better ones, yes.
> I have a table of flights which has several fields
>
> >T
