Unknown table in field list (MySQL in vb.net)
I use MySql.Data.MySqlClient.MySqlCommand and MySqlConnection
Public fillGridCmdTxt As String = "SELECT tblItems.part_num AS Part#,
tblCategory.category_description AS Category, " _
& " tblItems.item_name AS 'Item Name', tblItems.item_desc AS
Description, " _
& "tblItems.item_qty AS Qty, tblUnit.unit_name AS Unit,
tblItems.item_price AS 'Selling Price(Php)' " _
& "FROM tblUnit INNER JOIN tblItems ON tblUnit.unit_id =
tblItems.unit_id INNER JOIN tblCategory " _
& "ON tblItems.category_id = tblCategory.category_id "
and when i use executeNonQuery on MySqlCommand, it gives me an error... It
says that "Unkown table '*tblItems in field list*" even the table is
really existing on my database... a little help please?
No comments:
Post a Comment