(Error 3296)

  • Thread starter Thread starter daniel caparg
  • Start date Start date
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
 
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
 
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.
 
Back
Top