vb.net - Error on SQL Inner Join Statement -

i have 2 saved queries in microsoft access called current_ratio , quarterly_growth_rates. these 2 saved queries share same primary key. may not contain same data. how use , inner join statement show data these saved queries side side?

here code:

con.open() dim cmd3 oledbcommand = new oledbcommand("select * current_ratio c inner join quarterly_growth_rates g on (c.ticker = g.ticker) , ((iif(c.period = 4, c.year + 1, c.year)) = g.year) , ((iif(c.period = 4, 1, c.period + 1)) = g.qtr)", con) dim reader oledbdatareader = cmd3.executereader() dim da new datatable da.load(reader) datagridviewcalculations.datasource = da reader.close() con.close() 

i error @ da.load(reader) saying:

the provider not determine double value. example, row created, default double column not available, , consumer had not yet set new double value.

additional information:

i've been running code while using abbreviated set of data of approximately 15 stocks. scaled amount of data approximately 6,000 stocks , having problem.

the problem current_ratio query. if run select * current_ratio error. not if run select * quarterly_growth_rates