Information générale
Catégorie:
Codage, syntaxe et commandes
>Kevin,
>
>Thanks for the reply. However, when I tried this as follows
>
>SELECT Projectid, ;
> a.oecname AS ownname,;
> b.oecname AS engname,;
> c.oecname AS conname ;
> FROM curTemp1;
> JOIN tmpoec a ON curTemp1.Owner = a.oecid;
> JOIN tmpoec b ON curTemp1.Engineer = b.oecid;
> JOIN tmpoec c ON curTemp1.Contractor = b.oecid;
> INTO CURSOR curTEMP
>
>I get a table with each projectid being repeated for every oecid in the tmpOec table resulting in a huge resulting table. Have I left something out?
Don't use a, b, and c as the local aliases for the tables; that can cause some confusion. Try it like this:
SELECT Projectid, ;
Own.oecname AS ownname,;
Eng.oecname AS engname,;
Cont.oecname AS conname ;
FROM curTemp1;
JOIN tmpoec Own ON curTemp1.Owner = Own.oecid;
JOIN tmpoec Eng ON curTemp1.Engineer = Eng.oecid;
JOIN tmpoec Cont ON curTemp1.Contractor = Cont.oecid;
INTO CURSOR curTEMP
Tamar
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