Thank you for writing back.
The error happens on every record.
The error is near LEFT JOIN `table1` AS `NotMt`
ON(`table2`.`` notmt =`NotMt`.`id`)
No error near others ones like LEFT JOIN `table1` AS `Symp` ON
(`table2`.`symp` =`Symp`.`id`)
Table1 is the 2 records
id name created modified
created_by modified_by
------------------------------------------------------------------------------------------------------------
1 Yes 2010-07-01 11:01:01 2010-07-01
11:01:04 1 1
2 No 2010-07-01 11:01:01 2010-07-01 11:01:04
1 1
id tinyint(4) PK
name varchar(10)
created datetime
modified datetime
created_by int(11) UN
modified_by int(11) UN
Table2 is the 4 records
id p_id c_vd_id f_dt sign_f_dt c_h_id
c_m_id c_age_id diag symp air
notmt mod color tsttype corr_date
corr_amt def_amt def_dt def1_desc
def2_desc air_dt c_y_id c_m_id c_d_id f_comp
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 6 1 2010-08-01 2011-08-02 1
3 2 2 2 null
1 2 5 3
null null 0
null
null null null null 0
2 7 1 2010-09-01 2010-09-02 10
21 10 1 1 null
1 1 3 3 1999-01-01 7.00
0
null
null 14 1 1 1
3 9 1 2011-08-22
2011-10-03 12 3
4 1 1
null 1 1 6 3
2003-01-19 14.00 0
null
null 10 1 1 1
4 15 1 2011-12-01 2012-01-09 11
11 15 1 1 1
1 2 3 3 null
null 1 2010-01-01 1265 A>C (H771T) 3445
(+2) S<1 null 3 4 24 1
c_rev_id c_rev_dt rev_by created
modified created_by modified_by
----------------------------------------------------------------------------------------------------------------------------------------------
null null null 2011-09-07 12:11:30
2011-09-07 12:11:30 2 2
null null null 2011-09-08 14:32:08
2011-09-08 14:32:08 5 5
null null null 2011-10-10 13:05:36
2011-10-10 13:05:36 5 5
null null null 2012-09-13 14:31:55
2012-09-13 14:31:55 5 5
id int(11) PK
p_id int(11) UN
c_vd_id smallint(5) UN
f_dt date
sign_f_dt date
c_h_id smallint(6) UN
c_m_id smallint(6) UN
c_age_id smallint(6) UN
diag tinyint(4)
symp tinyint(4)
air tinyint(4)
notmt tinyint(4)
mod smallint(6) UN
color smallint(6) UN
tsttype smallint(6) UN
corr_dt date
corr_amt float(7,2)
def_amt tinyint(2)
def_dt date
def1_desc varchar(50)
def2_desc varchar(50)
air_dt date
c_y_id smallint(6) UN
c_m_id smallint(6) UN
c_d_id smallint(6) UN
f_comp tinyint(2)
c_rev_id smallint(6) UN
c_rev_dt date
c_rev_by varchar(50)
created datetime
modified datetime
created_by int(11) UN
modified_by int(11) UN
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.
