On Fri, May 25, 2012 at 12:56 PM, Puneet Kishor <punk.kish@gmail.com> wrote:
On May 25, 2012, at 12:52 PM, <gizmomathboy@gmail.com> wrote:
> On May 25, 2012 11:10 AM, Puneet Kishor <punk.kish@gmail.com> wrote:
> On May 25, 2012, at 10:02 AM, <gizmomathboy@gmail.com> wrote:

> > Is there a way to access multiple tables using SimpleCRUD without using foreign keys?
> > I have a relatively small database with a 3 tables or so but I don't have foreign keys between the tables.
> Using Dancer::Plugin::SimpleCRUD there doesn't seem to be a way (from reading the documentation or search around for examples) to access more than 1 table in the simple_crud() call. It does look like you can use FKs to pull them into that 1 table.

What about using an SQL view to create a single virtual table to use with SimpleCRUD?

http://www.w3schools.com/sql/sql_view.asp

Chris