Posted by datawench on August 30, 2010 at 10:04pm
2 followers
Jump to:
| Project: | Table Wizard |
| Version: | 6.x-1.3 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Issue Summary
Are joins along these lines supported?
MainTable <-- leftjoin <-- MappingTable <-- leftjoin <-- SecondaryTable
Assuming, of course, that appropriate fields exist in these tables such that I could perform such a join with a normal SQL statement.
I've tried to come at this several different ways, and I just don't see it.
Comments
#1
Have you created the necessary relationships in Table Wizard, on the Relationships tab? Then when creating a view starting from the MainTable, you should be able to add Relationships (top center of the edit form).