Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement