On Dec 11, 2007 6:30 AM, Volker Duetsch <[EMAIL PROTECTED]> wrote:
> Hi,
>
> select
> mnr,
> kw,
> sum(pzt),
> sum(uu),
> sum(u01),
> sum(u02),
> sum(u03)
> from mde
> where mnr=63210 group by kw, mnr
>
>
> results in:
>
> mnr kw sum(pzt)sum(uu) sum(
N. Kavithashree wrote:
when i retrieve records using follwg query :
select * from table where country='United States' and code='US';
Is the value if the country field "United States"? Or is it "United
States of America" or similar?
But if i give :s
select * from table where country like 'United S
- Original Message -
From: "muruganandam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 4:04 PM
Subject: selection from multiple tables;
>
> for a particular query i have to select data from five tables.
> can any one suggest me a best way to do that in
Nicola Sabbi writes:
> HI,
> I have the following table:
>
>
> desc keywords_news;
> ++--+--+-+-+---+
> | Field | Type | Null | Key | Default | Extra |
> ++--+--+-+-+---+
> | id_keyword | int(11) |
