[turba] a more complex turba source

[Tom H]

Hi,

I've got a project that turba is well suited to as a base, but the source
data is split over a number of tables similar to;

table_user (table1)
userID    PK
userName
userPass
userAddress1

table_attributes (table2)
attributeID    PK
attributeName
attributeValue

and each source has a different set of attributes, but the common base
fields from the user table.
Is is possible to configure a turba source to do a more complex query?
ie SELECT * FROM table_user LEFT JOIN attribute ON userID = attribute.user
WHERE userID = x

any ideas would be appreciated.

Cheers

T.