var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sql debug help
how can it be that
when I do the query
select * from rep where batch=133 it returns 730 and
select* from rep left JOIN Information ON rep.site = Information.Sitecode where batch=133 returns more then 730
I want it to return the same records as the first query but with the additional information from the information table --
what am i doing wrong?
I would say that the Information table has more than 730 records in it for batch 133.
no but the information table is just linked as a lookup for the site information -- batch is in the rep table not destination so how can second query have more then the first --
it is somehow returning duplicates because if I do select distinct before the second then it works -- but why is this happening?
because you have duplicate data
Originally Posted by esthera