left join in jtable

[Iran Modern Co]

Hello

i use of jtable and jform for edit and save form in joomla back-end.

i want know how may select more than one table in jtable for read data of mysql?default is one table.

thanks

[Mark Dexter]

You can override the JTable class for your situation. In this case, you could override the different methods for loading and saving and do the queries you need for both tables. Alternatively, if it works, you could perhaps make a view in the database that can be updated and inserted and then treat the view as a table in JTable. Here is a link: http://dev.mysql.com/doc/refman/5.0/en/view-updatability.html. Good luck. Mark

--
You received this message because you are subscribed to the Google Groups "Joomla! General Development" group.
To post to this group, send an email to joomla-de...@googlegroups.com.
To unsubscribe from this group, send email to joomla-dev-gene...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/joomla-dev-general?hl=en-GB.