От: | Grog13 | ||
Дата: | 29.05.09 13:45 | ||
Оценка: |
ID [PK]
SomeFields
ID [PK],
TID [FK T1.ID],
State
SELECT *
FROM T1
WHERE id IN
(
SELECT DISTINCT TID
FROM T1_States
WHERE State IN (1,2,3,4,5)
)
AND
id NOT IN
(
SELECT DISTINCT TID
FROM T1_States
WHERE State IN (6,7,8)
)