sql join 2 tables that are not related

Im trying to query two different tables and put the data into one gridview. The tables have some of the same columns, but there is no relation between the tables. I need to simply query the two tables with different "where" criteria but put the results in the same gridview (because the columns are the same)

Here is my query: (and i get an error "syntax error in From query")

AccessDataSource1.SelectCommand = "SELECT * FROM CARates, ShieldRates WHERE CARates.Area = '" & BCArea2.Text & "' And ShieldRates.Area = '" & BSArea2.Text & "' And (CARates.MinAge <= " & Val(DOB.Text) & " And CARates.MaxAge >= " & Val(DOB.Text) & ") And (ShieldRates.MinAge <= " & Val(DOB.Text) & " And ShieldRates.MaxAge >= " & Val(DOB.Text) & ") And (CARates.Contract = 'Single' Or CARates.Contract = 'Single Male') And ShieldRates.Contract = 'Single' And CARates.Category = 'Health Plans' And ShieldRates.Category = 'Health Plans' And (MemCount = Val('0') Or MemCount = Val('1') Or MemCount = Val('100')) And StartDate in (SELECT MAX(StartDate) FROM CARates ca WHERE ca.Product = CARates.Product)"
                    AccessDataSource1.DataBind()

Select allOpen in new window