Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi all,
I was just about to start on some elaborate code to do something, to which I feel a simple SQL might do the trick. Unfortunately, I can't get the trick!
I have 3 tables, which are basically Accounts tables which have different data, but certain common fields like ddate, cdetails, ncredit and ndebit. I need to create an updateable view which contains all the data from all the tables although on 2 tables I will be taking only the sum(ncredit), sum(ndebit) to prevent too many entries.Then, there's a certain unique linking field to create a link with the parent table if necessary, which will be used to create a sub-query if necessary, to display more detailed data from the individual table. The final view should look as if all the tables were merged into one neat view.
Any help, from anyone, please?
Regards,
Steve
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