select statement error?
From: shannon <shannon_at_nolunchmeat.com>
Date: Fri, 23 Jan 2004 22:50:43 +0100
Message-ID: <bus4tm$m1l$04$1_at_news.t-online.com>
Hi all,
Gray Pogo stick 1 28.00
Graham Pogo stick 1 28.00
Giles Pogo stick 1 28.00
Davids Pogo stick 1 28.00
Dalton Pogo stick 1 28.00
Cleaver Pogo stick 1 28.00
Brown Pogo stick 1 28.00
Date: Fri, 23 Jan 2004 22:50:43 +0100
Message-ID: <bus4tm$m1l$04$1_at_news.t-online.com>
Hi all,
i am experimenting on the online tool, SQLcourse 2 tutorial, and have entered the following query,
SELECT lastname, item, quantity, price
FROM items_ordered, customers
GROUP BY lastname DESC;
the answer I get looks like this,
Smith Pogo stick 1 28.00
Schultz Pogo stick 1 28.00
Sanchez Pogo stick 1 28.00
Sakahara Pogo stick 1 28.00
Moore Pogo stick 1 28.00
Mendoza Pogo stick 1 28.00
Keller Pogo stick 1 28.00
Jones Pogo stick 1 28.00
Gray Pogo stick 1 28.00
Graham Pogo stick 1 28.00
Giles Pogo stick 1 28.00
Davids Pogo stick 1 28.00
Dalton Pogo stick 1 28.00
Cleaver Pogo stick 1 28.00
Brown Pogo stick 1 28.00
DB shows only one pogo stick sold ( to dalton)
help Received on Fri Jan 23 2004 - 22:50:43 CET