Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with a where in a sql statement
Message
De
26/09/2003 12:21:13
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problems with a where in a sql statement
Divers
Thread ID:
00832743
Message ID:
00832743
Vues:
55
Hello, i'm creating a query but everytime i use the last condition it doesn't bring any results, this is my query:
select * from hardware h, usuarios_cia u, oficina o, modelos m, marcas ma, hard_local hl; 
where h.usuario=u.codigo and u.oficina=o.codigo and h.modelo=m.codigo and m.marca=ma.codigo;
and h.host=hl.host
And i know that accomplish this query, even i build a query in order to probe this:
select * from hardware, hard_local, tipo_local where hardware.host=hard_local.host and hard_local.tipo=tipo_local.tipo
what is wrong in the first query?
Thanks.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform