难!!SQL问题!!查找记录!! select b1.*from 表1 b1 Left Join 表2 b2 on b1.PO_NUMBER=b2.PO_NUMBER and b1.Line_No=b2.Line_Nowhere b2.PO_NUMBER IS NULL 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from 表1 where Line_NO not in(select Line_NO from 表2) 同意楼上的,但最好不要SELECT * fanks(凡可) 肯定不行!! 没有关键字!!就是很多组:PO_NUMBER Line_NO ITEM C020401-048ME 1 MTHVN0000024433 .0000 5C020401-048ME 2 MTHVN0000024421 .7000 15C020401-048ME 3 MTHVN0000014424 .7000 15C020401-048ME 4 MTHVN0000014435 .7000 15C020401-048ME 5 MTHVN0000014422 .7000 20C020401-049ME 1 MTHVN0000014425 .7000 20C020401-049ME 2 MTHVN0000014426 .7000 20C020401-049ME 3 MTHVN0000014426 .7000 20C020401-049ME 4 MTHVN0000014426 .7000 20表2、C020401-048ME 1 MTHVN0000024433 NULL NULL NULLC020401-048ME 2 MTHVN0000024421 NULL NULL NULLC020401-048ME 3 MTHVN0000014424 NULL 2002-02-06 C020401-048ME 4 MTHVN0000014435 NULL NULL NULLC020401-049ME 1 MTHVN0000014435 NULL NULL NULLC020401-049ME 2 MTHVN0000014436 NULL NULL NULLC020401-049ME 3 MTHVN0000014436 NULL NULL NULL求结果:C020401-048ME 5 MTHVN0000014422 .7000 20C020401-049ME 4 MTHVN0000014426 .7000 20 left join ... on ...肯定是可以的。我经常用! 有没有VB的教学视频啊 召唤高人,求字符串算法 treeview中有多个父节点,如何得到任意一个父节点下的所有节点? 急啊,VB的小问题 vb中有取当前路径的函数吗? 五一劳动节,我来送分…… 在data 控件中,有没有条件查询的方法.怎样运用.(不用sql 语句) VB下载网页代码的问题 挑战版主和所有VB高手,非高手不许进 是太简单吗?怎么没人睬我?我要实现类似于vb中属性窗口的dock(停靠)功能。急用急用。谁能帮我? 咋样让按钮保持按下状态?谢谢 为什么添加记录,刷新后/或提交后。有时能在数据库中找到,有时不能??
肯定不行!!
就是很多组:
PO_NUMBER Line_NO ITEM
C020401-048ME 1 MTHVN0000024433 .0000 5
C020401-048ME 2 MTHVN0000024421 .7000 15
C020401-048ME 3 MTHVN0000014424 .7000 15
C020401-048ME 4 MTHVN0000014435 .7000 15
C020401-048ME 5 MTHVN0000014422 .7000 20
C020401-049ME 1 MTHVN0000014425 .7000 20
C020401-049ME 2 MTHVN0000014426 .7000 20
C020401-049ME 3 MTHVN0000014426 .7000 20
C020401-049ME 4 MTHVN0000014426 .7000 20
表2、
C020401-048ME 1 MTHVN0000024433 NULL NULL NULL
C020401-048ME 2 MTHVN0000024421 NULL NULL NULL
C020401-048ME 3 MTHVN0000014424 NULL 2002-02-06
C020401-048ME 4 MTHVN0000014435 NULL NULL NULL
C020401-049ME 1 MTHVN0000014435 NULL NULL NULL
C020401-049ME 2 MTHVN0000014436 NULL NULL NULL
C020401-049ME 3 MTHVN0000014436 NULL NULL NULL求结果:
C020401-048ME 5 MTHVN0000014422 .7000 20
C020401-049ME 4 MTHVN0000014426 .7000 20