Multiple table search

[Gregory Kowalski]

Hello,

This is my first foray into multiple table searches and would greatly 
appreciate some guidance.

As an example lets say I have two table with following content: :

aTable

fieldone       fieldtwo
1001             1002



bTable
fieldthree     fieldfour
1003             1004


I want to query fieldtwo and fieldfour at once for a value (1004).

I tried:

  whichSearch = "select *  FROM aTable, bTable where fieldtwo = 
'"&"1004"&"' OR fieldfour = '"&"1004"&"' "


but it crashes.

I also tried

  whichSearch = "select *  FROM aTable, bTable where atable.fieldtwo = 
'"&"1004"&"' OR bTable.fieldfour = '"&"1004"&"' "

and it also crashes.



What is the correct syntax?

Thank you

Greg