Correction to the sql statement....

Select Customer_Name, Customer_Telephone, Order_Amount from Orders
where Order_Amount > 100

On Feb 7, 5:55*pm, SpreadTooThin <bjobrie... (AT) gmail (DOT) com> wrote:
Is it really this simple?

SELECT table1.column1, table2.column2 FROM table1, table2 WHERE
table1.column1 = table2.column1;

Really? I would have thought there needed to be nested select
statements...
Is this an oversimplification?
Here the WHERE statement is a comparison between the two tables?
What happens when the WHERE statement is only on one or the other?

On Feb 7, 6:02*pm, SpreadTooThin <bjobrie... (AT) gmail (DOT) com> wrote:
Pardon me if I talk to myself while I wait for answers...

select Customer.Customer_Name, Customer.Customer_Telephone,
Orders.Order_Amount from Customer, Orders where Orders.Order_amount <
100

What doesn't seem right here is that shouldn't there be two selects
here? an inner and an outter?

This being the inner select
Select Customer_Name, Customer_Telephone, Customer_ID from Customer
and this being the outer select
Select Customer_ID, Order_Amount from Orders where Order_Amount > 100

On 2/7/2011 8:16 PM, SpreadTooThin wrote:
No, you don't need two SELECT statements. That's what relational
databases are all about - relationships between entities in different
tables.

Your WHERE clause will work, but it's much better to use a JOIN. It is
more flexible and separates the selection criteria from the relationship
criteria, i.e.

SELECT c.Customer-Name, c.Customer_Telephone, c.Customer_ID,
o.Order_Amount
FROM customer c
JOIN Order o on c.Customer_ID = o.Customer_id
WHERE o.Order_Amount > 100

Note I use aliases ('c' and 'o'). I always use them when joining tables
for clarity (and to eliminate errors where two tables contain the same
column name, as Customer_ID appears here).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================