在网上看到以下的例句,不知道如何转为MsSql语句,自己试着转,可是出错,请路过高手给点提示,不胜感激!谢谢!
SELECT "t_cell_a"."f_9",
"t_cell_a"."f_8",
"t_cell_a"."f_7",
"t_cell_a"."f_6",
"t_cell_a"."f_5",
"t_cell_a"."f_4",
"t_cell_a"."f_3",
"t_cell_a"."f_2",
"t_cell_a"."f_1",
"t_cell_a"."f_10",
"t_cell_a"."f_11",
"t_cell_a"."f_12",
"t_cell_b"."f_12",
"t_cell_b"."f_11",
"t_cell_b"."f_10",
"t_cell_b"."f_9",
"t_cell_b"."f_8",
"t_cell_b"."f_7",
"t_cell_b"."f_6",
"t_cell_b"."f_5",
"t_cell_b"."f_4",
"t_cell_b"."f_3",
"t_cell_b"."f_2",
"t_cell_b"."f_1",
"t_jzpz"."f_date",
"t_jzpz"."f_pzh",
"t_jzpz"."f_zy",
"t_jzpz"."f_km",
"t_jzpz"."f_jfje",
"t_jzpz"."f_dfje"
FROM {oj "t_cell" "t_cell_a" LEFT OUTER JOIN "t_cell" "t_cell_b" ON "t_cell_a"."f_12" = "t_cell_b"."f_12"}, {oj "t_jzpz" LEFT OUTER JOIN "t_cell" "t_cell_a" ON "t_jzpz"."f_date" = "t_cell_a"."f_12"}
------解决方案--------------------
把双引号都去掉,什么时候在查询分析器里运行通过啦,就没问题啦
------解决方案--------------------
把{oj }之类的去掉
把连接换成两个 LEFT OUTER JOIN