Below is code I am using to get data from a table called trans and one called seller. It works fine except the WHERE does not seem to be working. I get all the rows from the trans table (about 15,000) when there are only there are only 360 with a date of '2013-04-11'. Any Ideas? Thanks.