General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>My view designer is greyed out.
>
>Errr, how did you create the View then?
I WAS using the wizard (don't know why - I hate wizards) so I went in and created on the real way (my designer's not greyed out anymore). I went into my primary tables and loaded them with data according to the relations. BUT I still get no data when I browse my view. Anyway, here's the SQL you requested...
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;
INNER JOIN inventory!customers ;
ON Customers.cust_id = Transactn.cust_id ;
ON Inventory_in.trans_id = Transactn.trans_id;
GROUP BY Customers.company;
ORDER BY Inventory_in.stocknum
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only