SQLite的where语句查询不出结果

左手千千 2016-10-28 05:34:16

有两张表，建表的sql语句：

String sql1 = "create table if not exists bc_product_brand_category ( " +

                " productBrandId INTEGER NOT NULL," +

                " productCategoryId1 INTEGER NOT NULL," +

                " productCategoryId2 INTEGER," +

                " productCategoryId3 INTEGER NOT NULL," +

                " PRIMARY KEY ( productBrandId, productCategoryId3));";



 String sql2 = "create table if not exists bc_product_brand (" +

                " productBrandId INTEGER PRIMARY KEY AUTOINCREMENT," +

                " brandName varchar(255) NOT NULL," +

                " pinyin varchar(255));";

然后用这些sql语句插入数据

INSERT INTO `bc_product_brand` VALUES ('1', '联想', 'lianxiang');

INSERT INTO `bc_product_brand` VALUES ('2', '戴尔', 'daier');

INSERT INTO `bc_product_brand` VALUES ('3', '苹果', 'pingguo');

INSERT INTO `bc_product_brand_category` VALUES ('1', '62', '73', '74');

INSERT INTO `bc_product_brand_category` VALUES ('1', '62', '73', '76');

INSERT INTO `bc_product_brand_category` VALUES ('1', '62', '73', '77');

INSERT INTO `bc_product_brand_category` VALUES ('2', '62', '73', '74');

INSERT INTO `bc_product_brand_category` VALUES ('2', '62', '73', '76');

INSERT INTO `bc_product_brand_category` VALUES ('3', '62', '73', '74');

INSERT INTO `bc_product_brand_category` VALUES ('3', '62', '73', '76');

然后用这条sql查询语句查询：

SELECT DISTINCT bc_product_brand.productBrandId, bc_product_brand.brandName, bc_product_brand.pinyin FROM bc_product_brand LEFT JOIN bc_product_brand_category ON bc_product_brand.productBrandId = bc_product_brand_category.productBrandId WHERE bc_product_brand_category.productCategoryId1 =74 OR bc_product_brand_category.productCategoryId2 =74 OR bc_product_brand_category.productCategoryId3 =74

发现第一次运行app，创建数据库，插入数据后查询是可以得到结果的，但是以后每次运行app的时候就再也查不出结果了，尝试去掉where语句，就能查询出结果，想请教一下这是何故？