Do you know how to program? Any chance of going to D7? If you can code a query and do a bit of PHP, I'd bet you can do this without any modules faster than unravelling all the modules. And it would be considerably easier with the new object form of queries in D7.
But you get by the single table problem in Views by building relationships.
From: Austin Einter
Now I have downloaded Data module and enabled all the related modules as mentioned below.
1. Schema , 2. Search, 3. Data, 4. Data Admin UI, 5. Data Node, 6. Data search and 7. Data Taxonomy
(Do I need really those many modules, can I disable few from above)
I am using Drupal 6.20.
In my case, I have already tables created, data is entered through a form and saved into corresponding tables.
So for table creation, deletion, storing data into table, deleting data from table is done by a custom module already developed.
I am looking at Data module to scan through multiple tables with conditions (using JOIN, WHERE clause etc across tables) and show the filtered data in a view.
But I am not able to locate the related documents that will guide me how to proceed further. On google search I found
http://drupal.org/node/580650 provides some information, but probably not suffiecient.
On further exploring, I went to Administer->Site Building->Data Tables.
There I see a tab "Adopt tables". Under that I can see the tables created by my module (around 5 tables). Do I need to select those tables and adopt?????
After doing adopt, if I select a particulr table I see multiple tabs such as " Edit schema, Edit title, Configure search, " etc, Do I need to alter any default thing here.
And finally I saw the view creation page. I can see the tables those were created by my custom module.
Looks I can select only one table at a time. I am looking for showing the records where a particular condition is met across multiple tables. Say show all the user records where user is 40 years old and working in Texas. How can I acheive it?