Hello list, I got a sql query that's is just beating me (5-0). Have have
read here and there, and MySQL Query Browser is just fed up with all the
tries I have made it do. It is just not working.
First, the tables (simplified version, if need more info just tell me):
[shipments]
ID int
-Original Message-
From: James M. Gonzalez
Sent: 12 August 2005 16:58
To: 'Scott Noyes'
Subject: RE: Complex query. (It's killing me)
Sorry, I will explain myself more clearly:
Everyday, we ship packages, and we also receive some packages.
The one we receive, has been shipped by us
of conditions (like where clausules)
James
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 12 August 2005 16:41
To: [EMAIL PROTECTED]
Cc: James M. Gonzalez; mysql@lists.mysql.com
Subject: Re: Complex query. (It's killing me)
Sorry - I think you need a LEFT
Hello list! little GROUP BY problem here:
Table 'shipments'
ID int(10)
CompanyName char(50)
WhatToShip char(50)
TrackingNumber char(50)
SerialNumber char(50)
I would like to obtain the following results:
CompanyName - WhatToShip - Ready - Almost - Done
Foo
Greetings,
I'm facing a difficult query at the moment. I have tried many different
queries but still not get the desired result.
My case:
Tables:
shipped ( id, shipdate, sn);
undelivered (id, undate, sn);
return (id, redate, sn);
I need the following output:
DATE
Hello list!
Im loading rows from a txt tab separated fields file into a MySQL table.
It mostly works, but the date format in one field is not the type that
MySQL likes. So right now Im loading it as a char field. Yes, it is ugly
and a pain to work with. I would like to some how automate it and