Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Four Table Join using same table twice.
I'm trying to build an updateable, parameterized, local view from three source tables, where one of the tables is used twice, and my (limited) SQL experience isn't enough. I've made several attempts that were wrong, including FORCE, so it's time to ask for help.
LEADS iLeadPrimaryKey, iSourceKey, iNoteKey
SOURCE iSourcePrimaryKey, iNoteKey
NOTES iNotePrimaryKey
LEADS should join SOURCE on Leads.iSourceKey=Source.iSourcePrimaryKey
LEADS should join NOTES on Leads.iNoteKey = Notes.iNotePrimaryKey
^ This works fine.
NOTES should join SOURCE on Source.iNoteKey = Notes.iNotePrimaryKey
^ Adding this gives either an empty result set, or with Notes being duplicate values, depending. It should give a different set of Notes.
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