<div dir="ltr"><div><div><div><div>After upgrading to new DBIX version my JOIN statement is failing, here is the query in new and old version <br><br>** WORKING in this version<br><br>DBIx Version: 0.08195 <br><br>SELECT * FROM "AlertContact" "me" JOIN "AlertProfile" "Profile" ON "Profile"."Id" = "me"."ProfileId" WHERE ( ( "Profile"."Refe<br>
renceId" = ? AND "me"."Name" = ? ) ): '1', 'Email' <br></div><br><br></div><div>** NOT WORKING in this version<br><br>DBIx Version: 0.08250<br><br>SELECT * FROM "AlertContact" "me" JOIN "AlertProfile" "Profile" ON "Profile"."Id" <b>IDENT</b> ? WHERE ( ( "Profile"."ReferenceId" = ? AND "me"."Name" = ? ) )" with ParamValues: 1='me.ProfileId', 2='1', 3='Email']<br>
<br></div>I see extra keyword IDENT in JOIN statement, Can you please let me know <br></div>how to fix it?<br><br></div>Thanks,<br>Sheeju<br></div>