Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Specifing a column in the where clause
Message
De
19/02/2004 18:43:11
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Specifing a column in the where clause
Divers
Thread ID:
00879002
Message ID:
00879002
Vues:
56
In this example:

select customer_id,customer_nme,(select sum(sell_amount) from sales where sales.customer_id=customer.customer_id) as sales_total
from customer
where sales_total>0
order by 3,2 desc

Why do I get the error message: Invalid column name 'sales_total'?
Is there a way around this without having to repeat the query in the where command (similar to the order command where you just specify the column number)?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform