cartesian product in sql query - c#

See more:

C#

SQL

SQL-Server

Hello guys.

I have a problem with the sql query in C# :(.

here is the code:

dts.Tables.Clear();
           
SqlDataAdapter da = new SqlDataAdapter("SELECT t.Date, t.Barcode, t.Name, t.Quantity, d.BuyPrice, t.SellPrice FROM tblSales t, tblMagazine d WHERE t.Date BETWEEN '" + DateTimePicker1.Value + "' AND '" + DateTimePicker2.Value + "'", con);

da.Fill(dts);

dataGridView1.DataSource = dts.Tables[0];

It gives me cartesian product or something like that.... because when I click the button (that has this code) it shows me more tables than I have in the table Sales.

What is the problem ?? Can someone help me