i want to query two related access tables in vb 6 and dispaly the records in a datagrid but i am getting an error message.see example code below
sql1 = (“select * from Statistics,Hospital Where “)
sql1 = (“sql1 & statistics.Hospital = ‘hospital.hospital’ & hospital.class=’Referal ‘ & or & hospital.class =’provincial’ “)
‘sql1 = (” sql1 & & and disease = ‘cancer’ “)
