raghuveer126 (10/24/2012)

---

Hi I have something like this and the tables have no foreign keys. I am using date in where clause and i am not able to use id because it is deleting al the data.

DELETE t1 FROM table1 t1

INNER JOIN table2 t2 ON
t1.id= t2.id
and t1.code= t2.code

inner join table3 t3 on
t2.id=t3.id
t2.code=t3.code

WHERE t3.date IN
(
SELECT [DATE] FROM t3
WHERE CNTYCODE IN('A', 'B', 'BA', 'G', 'N')
AND [DATE] < '01/14/2010']

UNION ALL
-- Region-I
SELECT [DATE] FROM t3
WHERE CNTYCODE IN('c', 'd', 'e', 'f', 'k')
AND [DATE] < '01/14/2010']
)

can i use this way or no.

WHERE t3.date > '01/14/2010'
and t3.CNTYCODE IN('A', 'B', 'BA', 'G', 'N', 'c', 'd', 'e', 'f', 'k')