SQL |
Hello,
I build a query with query builder and sqlsrv driver, with this code $this->join("[Ultrafog Sp_ z o_o_\$Production BOM Line] as job_items", "job_line.No_ = job_items.[Production BOM No_]", 'LEFT'); the driver generate this wrong query LEFT JOIN "ultrafog_prod"."dbo"."[Ultrafog" Sp_ z o_o_$Production BOM Line]" as "job_items" ON "job_line"."No_" = "job_items"."[Production BOM" "No_]" Seem it have problem with column and field name with space ignoring square bracket Some one konw a work around? |
Welcome Guest, Not a member yet? Register Sign In |