<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Editing only one of the tables that are joined together?</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/editing-only-one-of-the-tables-that-are-joined-together</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/editing-only-one-of-the-tables-that-are-joined-together/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>Prankie on Editing only one of the tables that are joined together?</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/editing-only-one-of-the-tables-that-are-joined-together#p31450</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/editing-only-one-of-the-tables-that-are-joined-together#p31450</guid>
        	        	<description><![CDATA[<p>JQgrid is working really nice when there is only one table involved. But I was wondering if it's possible to get it to work with multiple tables as well.</p>
<p>Lets say I have two tables</p>
<p><strong><em>customer</em></strong> table has cuid, name, gender, cityid<br />
<strong><em>city</em></strong> table has cityid, cityname, citysize</p>
<p>And they are joined together like this</p>
<p>select cuid, name, cityname, citysize<br />
from customer cu<br />
left outer join city ct on cu.cityid = ct.id</p>
<p>1. How can I edit that only customer table is updated?<br />
2. If I want to edit both at the same time, how do I do that instead?</p>
<p>Thanks</p>
]]></description>
        	        	<pubDate>Fri, 12 Dec 2014 03:12:09 +0200</pubDate>
        </item>
</channel>
</rss>