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 don't want
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
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
Table:
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 flight_group