sql command delete..?

angel_winx84 · #1 19th Mar 2007, 05:45 PM

how to write command for...delete all data in table 1 that related wit table 2 that contain the word "you"...

strayinma · #2 19th Mar 2007, 08:01 PM

DELETE FROM table1 WHERE field1 in (SELECT field1 FROM table2 WHERE field1 LIKE '%you%')

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Command and Conquer: 3 Tiberium Wars (PC)	sally5027	PC & Console Gaming	9	5th Oct 2008 06:58 AM
Command and Conquer 3: Kane's Wrath	thingie2	PC & Console Gaming	6	9th Sep 2008 12:14 PM
CMD command to compare file modified?	MJM	Windows Operating Systems	3	25th Mar 2008 01:05 PM
How do I delete this?	bol1	Windows Operating Systems	5	21st Jan 2008 10:29 AM
Command and conquer generals	mxmad32	PC & Console Gaming	1	29th Nov 2007 08:39 PM