troubleshooting Question

sql join 2 tables that are not related

Avatar of mlg101
mlg101Flag for United States of America asked on
Microsoft AccessVisual Basic.NETSQL
1 Comment1 Solution292 ViewsLast Modified:
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)"

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros