二个表相同记录过滤SQL写法

[米家]

表一，Expense

private Project project;
private String type;
project type
2 L3_03
3 L3_03
4 L3_01

表二，Project
private Long id;
id
1
2
3
4
查询 Project 过滤 Expense 表字段（project type）相同id的值
则显示 表
Project
id
1
4

[米家]

[Quote=引用 2 楼 fredrickhu 的回复:]

SQL code
select * from Project t where not exists (select 1 from Expense from Project = t.Project and type = t.type)
[/Quote]
只要根据type判断 关联表是否显示数据就可以了
select * from T_PROJECT t where not exists (select 1 from T_EXPENSE from t.f_type ='ZHL3_WK_03')
不对啊- -！！我是用SQL查询分析
错误为
服务器: 消息 156，级别 15，状态 1，行 1
在关键字 'from' 附近有语法错误。

[稻草_木偶]

select * from T_PROJECT t where not exists (select 1 from T_EXPENSE from t.f_type ='ZHL3_WK_03') 改成where

[dawugui]

没看懂你的内容,如果是Project
select t2.* from t2 where Project not in (select Project from t1)

如果是project + type
select t2.* from t2 where not exists (select 1 from t1 from t2.Project = t1.Project and t2.type = t1.type)

[--小F--]

select * from Project t where not exists (select 1 from Expense from Project = t.Project and type = t.type)

[米家]

我是用ssh做的
下面是我的model定义
表二 ：Expense.java
private Project project; //关联 Project.java
private String type; //类型
表二：Project.java
private Long id; //编号（主键）
如果Expense 信息 type="L3_03" 外键id（Project）信息不显示

主要显示Project 表信息