2. PHPRunner General questions
  3. [SOLVED]  Problem with INNER JOIN
This topic is locked
[SOLVED]

 Problem with INNER JOIN

 		5/8/2012 10:32:17 AM
PHPRunner General questions
S
 stiven author

Hello,
I created an INNER JOIN on the edit page with two tables.
table one
case_no

dec_name

v_date

v_time
table two

case_no

dec_name

notes
I am displaying all columns on table one and the notes column on table two. on the edit page when i try to save the record i get error unknown column 'notes' in field list
Thanks for your help
Sergey Kornilov admin 5/8/2012

Check this article that explains how to update joined tables:

http://xlinesoft.com/phprunner/docs/update_multiple_tables.htm
S
 		stiven author 5/8/2012

Thanks that worked.