(Error 3296)

D

daniel caparg

Dear,
i need some help,
i try run this sql, but ans error 3296 over each conditions:

SELECT coco_sector ,
coco_USM ,
coco_Center ,
coco_Tecno ,
*
FROM coco
LEFT JOIN Reservated
ON ([coco_sector] = [res_sector])
AND (coco_USM = Res_USM)
AND (coco_Centro = Res_Centro)
AND (coco_Tecno = Res_Tecno);

tks
 
L

Lord Kelvan

well that error is about your joins is there any reason you are
joining 4 fields in the one table. What you seem to be doing is
having massive reduandcy in your data and your select is off as well
because you are double selecting data because of the wildcard *

do you not have an id that links the two tables together
 
J

John W. Vinson

Dear,
i need some help,
i try run this sql, but ans error 3296 over each conditions:

SELECT coco_sector ,
coco_USM ,
coco_Center ,
coco_Tecno ,
*
FROM coco
LEFT JOIN Reservated
ON ([coco_sector] = [res_sector])
AND (coco_USM = Res_USM)
AND (coco_Centro = Res_Centro)
AND (coco_Tecno = Res_Tecno);

tks
Click to expand...

You probably need to specify the table name and field name in each JOIN clause
portion, and get rid of some parentheses: try

SELECT coco_sector ,
coco_USM ,
coco_Center ,
Reservated.*
FROM coco
LEFT JOIN Reservated
ON [coco].[coco_sector] =[Reservated].[res_sector]
AND [coco].coco_USM = [Reservated].Res_USM
AND [coco].coco_Centro = [Reservated].Res_Centro
AND [coco].coco_Tecno = [Reservated].Res_Tecno;

That's a pure guess, of course, since I know nothing about the structure of
your tables, their relationships, or the meaning of these fields.
 
Top