Hi,

I need to combine info from different tables (contactdetails + account details + contactaddress) before syncyng with outlook.

Seem mysql 4.1 does not support VIEWS.

How can I solve this issue with a SQL SELECT and where shoudl I put it in GeniusConnect ?

Please be aware a "read only" feature from DB to outlook would be enough for the moment, so not really syncing mandatory if this makes life more difficult ..

Many thanks for your advise

G

Hi,

90% of database systems are supporting VIEW's, thats why we don't support custom SELECT queries in GeniusConnect.
If your database has no support for VIEW's, the only solution will be to run a query to collect the data and insert the result to a DummyTable, then use this table in GeniusConnect.