下面我有我測試過的 SQL 查詢工作正常Select data_info.user_id, data_info.type_id, data_info.specific_title, data_info.content, life_area.type_id, life_area.type_idFrom data_info Left Join life_area On data_info.type_id = life_area.idWhere data_info.user_id = '0001'現在我試圖將工作 SQL 轉換為 asp.net MySqlCommand,但它無法工作并顯示語法錯誤MySqlCommand cmd = new MySqlCommand( "Select data_info.user_id,data_info.type_id,data_info.specific_title,data_info.content,"+ "life_area.type_id,life_area.type_id" + "FROM data_info LEFT JOIN life_area ON data_info.type_id = life_area.id" + "Where data_info.user_id='0001'" , conn);
- 1 回答
- 0 關注
- 267 瀏覽
添加回答
舉報
0/150
提交
取消