为什么我的SQL语句运行得不到我想要的结果????
一杯咖啡 2001-11-02 10:34:25 我有两个表:
tbl_invoice(
invoice_id number(8);
invoiceno char(12));
tbl_transport(
transport_id number(8);
invoiceno char(12);
notes char(200));
语句:
select * from tbl_invoiceno where invoiceno in (select invoiceno from tbl_transport);
明明两个表中都有相同的invoiceno记录,为什么查询结果会是空呢???
是不是因为invoiceno是char型???