how about something like this, which finds one row (if any) with the
lowest in-stock price, UNIONs it with the highest out-of-stock price (if
any), and then returns just one row, including whether that was an
in-stock or out-of-stock price:
(SELECT col1, price, quantityOnHand, 1 as inStock
FR
Hey list;
I have a case where I need to fetch a product row from a table
containing price information about some products, and where every
product can have multiple rows but from different suppliers (thus with
different prices and stock information).
However, I'm trying to create a query which f
On Thu, 11 Jan 2001, Tõnu Samuel wrote:
> We still try to answer questions and value your time. Just some
> questions are repeating up to 3 times per day, other people do not
> provide any data with their questions and finally all MySQL
> development goes slower because this. We are providing fre
From: "Neil Davis" <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 6:58 PM
> Guys,
>
> Amen. When I was 13 and got my first commodore 64, I decided to teach
myself
> BASIC. All I had was the manual. (the MySQL manual is the library of
> If it is documented somewhere, and can be produced
uarantee you'll several different versions.
- Original Message -
From: "Neil Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 1:58
Subject: Re: Lazy
> Guys,
>
> Amen. When I was 13 and got my first commodore 64, I decide
admin that sometimes I transgress out of panic and usually quickly get
> corrected, but I don't cry about it; I remember where I am, why I am here,
> and solve the problem with the available information. I still haven't been
> beat by a problem.
>
> L8,
> Neil
&g
]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 11:17 AM
Subject: Re: Lazy
> Interesting. My guess is that you must be in your early 20s. When I was
at
> high school (& even uni), apart from normal lessons, researching for
> assignments, etc, meant going to the li
nly be there as a guide
> but would never give us the answer. I guess the quality of teaching and
> graduates have dropped greatly since I left high school.
>
> Cheers
>
>
> - Original Message -
> From: "John Cichy" <[EMAIL PROTECTED]>
> T
ED]>
To: "Don" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 0:47
Subject: Re: Lazy
> Human nature and education...
>
> In most cases as youngsters we are 'given' the answers and the methods for
> solving our problems. As we get ol
Human nature and education...
In most cases as youngsters we are 'given' the answers and the methods for
solving our problems. As we get older we continue to expect this and un-able
to function when told to figure something out.
My first computer class in High school (NCR Mainframe/BASIC), I h
t;
> > -Original Message-
> > From: Eric Fitzgerald [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, January 11, 2001 12:29 PM
> > To: Carlos Corzo; [EMAIL PROTECTED]
> > Subject: Re: Lazy
> >
> > Some people have looked at the manual's, ye
> Carlos Corzo wrote:
>
> > Some people have tried the manuals verbatim but are really confused
> > because they are not at your intellectual level. If this list is for
> > the "intelligent only", change the title please. Not everyone can
> > decipher a manual. I may post questions but there ar
Hi,
May I offer a bit of distraction and an idea?
Below might draw flames of (browse the site), but I like databases because
they turn me on
I am a recovering micsofrot addict. WHEW! It feels good to get that off my
chest. I am also a Linux newbie (Since 12-00) and am exploring MySQL. I hav
Quentin Bennett writes:
> Perhaps, along with the 'Please check the manual' message at the end of all
> messages, there should be a reference to a reliable archive, allowing list
> users who are referred to the archive an easy way of finding it!
Done.
--
__ ___ ___ __
/ |/ /_
ald [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 11, 2001 12:29 PM
> To: Carlos Corzo; [EMAIL PROTECTED]
> Subject: Re: Lazy
>
> Some people have looked at the manual's, yes, and it's pretty simple to
> determine when they have. If the question they ask can b
> I didn't wanted to make you upset. We still try to answer questions and
> value your time. Just some questions are repeating up to 3 times per
That's great coming from a great team.
Who knows ? There might be people who are tasked to frustrate you and this
group.
For the benefit of the open-sour
Aaron Schlesinger wrote:
> I agree with Carlos's response below. Tõnu I appologize for singling you
> out, but if you push away those simple questions, you'll just force those
> who are just getting started to find more patient people and software to
> use.
Critics is good :). I try to be more p
Is there any way that the list in question can be broken up into two lists?
For example, ASP has two (actually, alot more) lists called ASPFreeForAll,
and ASPAdvanced which cater to the various knowledge levels of each list's
participants.
The ASPAdvanced list is moderated by the person who cre
nsiderate of others.
>
> Eric Fitzgerald
> Server Administrator
> AMN Television Marketing
> - Original Message -
> From: "Carlos Corzo" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 10, 2001 2:58 PM
> Subject: Lazy
e just getting started to find more patient people and software to
use.
Aaron
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tõnu Samuel
Sent: Wednesday, January 10, 2001 6:44 PM
To: Carlos Corzo
Cc: [EMAIL PROTECTED]
Subject: Re: Lazy
Carlos Corzo wr
At 05:58 PM 1/10/01, Carlos Corzo wrote:
>Some people have tried the manuals verbatim but are really confused
>because they are not at your intellectual level. If this list is for
>the "intelligent only", change the title please. Not everyone can
>decipher a manual. I may post questions but the
Carlos Corzo wrote:
> Some people have tried the manuals verbatim but are really confused
> because they are not at your intellectual level. If this list is for
> the "intelligent only", change the title please. Not everyone can
> decipher a manual. I may post questions but there are reasons
ail to the list asking a
question that is very clearly answered in the manual, then I think your
being inconsiderate of others.
Eric Fitzgerald
Server Administrator
AMN Television Marketing
- Original Message -
From: "Carlos Corzo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED
Some people have tried the manuals verbatim but are really confused
because they are not at your intellectual level. If this list is for
the "intelligent only", change the title please. Not everyone can
decipher a manual. I may post questions but there are reasons for
them. My time is just as
24 matches
Mail list logo
