eVB database problem

[Kuba]

Hi,

This is my first message to this forum, so hi everyone :-).

I use eVB and have a pocketpc2002 device (iPAQ).
I have a problem with runninh such query:
select tableA.name inner join tableB on (tableA.name = tableB.name)

It seems like every query that ries to retrieve data from more than one table doesn't work.
Is this some sort of a limit for PocketAccess or am I doing something wrong ?

Can somebody give me an example of a working query ?

regards
Kuba

[Kuba]

well, the brackets caused an error
without brackets it works

but I have another problem now

how to join tables by 2 fields
... inner join tableA.field1 = tableB.field1 and tableA.field2 = tableB.field2

this doesn't work
it doesn't work with brackets either

anyone did this before and knows what's wrong ?


Kuba

[refractor]

[Kuba]

[refractor]

[Kuba]