Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table or View?
Message
From
30/06/2000 10:20:11
 
 
To
29/06/2000 23:44:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00386724
Message ID:
00387053
Views:
24
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform