Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table or View?
Message
De
30/06/2000 10:20:11
 
 
À
29/06/2000 23:44:35
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00386724
Message ID:
00387053
Vues:
21
One distinct possibility is that there are no records that match the join conditions (esp. since you are using inner joins). One other potential issue is the View Designer doesn't handle joins of more than two tables very well. IMHO it seems to be constructing the SQL wrong. It should be like this:

SELECT Customers.company, Inventory_in.chgperkt, Inventory_in.clarity,;
Inventory_in.colors, Inventory_in.cut, Inventory_in.entered,;
Inventory_in.invoiced, Inventory_in.removed, Inventory_in.inactive,;
Inventory_in.karatwt, Inventory_in.measure, Inventory_in.p_descript,;
Inventory_in.stocknum, Inventory_in.total_chg, Transactn.track_num,;
Transactn.transdesc;
FROM inventory!inventory_in
INNER JOIN inventory!transactn;
ON Inventory_in.trans_id = Transactn.trans_id;
INNER JOIN inventory!customers ;
ON Customers.cust_id = Transactn.cust_id ;
GROUP BY Customers.company;
ORDER BY Inventory_in.stocknum

You might try firing that off in the command window and see what kind of results you get.
Dan LeClair
www.cyberwombat.com
SET RANT ON - The Wombat Blog

Life isn’t a morality contest and purity makes a poor shield. - J. Peter Mulhern
Disclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform