Here is my sql statement:
Code: Select all
SELECT items.id,items.sku,order_info_item_binding.editing_name, order_info_item_binding.editing_desc, " +
"order_info_item_binding.qty,order_info_item_binding.id,items.uom,order_info_item_binding.item_location_id From order_info " +
"LEFT JOIN order_info_item_binding ON order_info.id = order_info_item_binding.order_info_id " +
"left join items on items.id = order_info_item_binding.item_id
Code: Select all
mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = cl_commandSets.selectQuery(commandID, where, orderby);
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(mySqlCommand);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
Any help on this would be GREATLY appreciated.