Join Expression Not Supported??

[Timinator]

Is there a trick to doing a Join in VB code? I've tried many ways, but i always get the error "Join Expression Not Supported". Below is an example of what i tried last.

SELECT * FROM PartTable INNER JOIN OrderTable ON pt_part_number = ot_part_number

Any ideas?

Thanks.

Tim

 

[Sawatzky]

Dear Tim,

try to leave out the INNER in your expression.
What is possible with sql-statements strongly depends on the connection you have and what kind of database you use.

regards Astrid