FEPS Database

Query:	select distinct p.id,source,prop,p.val from prop p,sou s,sounames sn where s.id=p.id and s.sou=sn.sou and code=8 and val<100 and ibest=1

id	source	prop	val
41	1RXS J031907.4+393418	4153	<10
48	HE 767	8311	10
96	vB 49	11059	1
104	vB 79	4547	<10
111	vB 93	11089	1
113	vB 96	4863	<10
115	vB 183	4860	<10
116	vB 97	4864	<10
117	HD 29231	4199	<10
118	vB 99	4865	<10
119	vB 106	8943	0.9
123	vB 143	4202	<10
124	HD 31143	6561	0
147	HD 47875	8254	10
155	HD 69076	4577	<10
175	HD 88742	9013	0.9
187	HD 92788	9023	0.3
194	HD 98553	9038	0.1
195	HD 99565	4852	<10
200	HD 102071	9058	0.0
204	HD 104576	4821	<10
211	HD 106156	9073	0.9
236	HD 121320	9088	0.3
259	HD 138004	9123	0.0
266	RX J1544.0-3311	4588	<10
295	HD 153458	9163	0.2
317	HD 193216	7034	1
336	HD 212291	9283	0.8
Select new table

Query:	select distinct id from sou where id not in (select id from prop where code=8 and ibest=1);