Page 1 of 1
sql query problem
Posted: Mon Jun 07, 2010 7:05 am
by mayanktalwar1988
Code: Select all
insert into distinctlinks select * from distinctfiller except select * from distinctlinks
is the above query the valid one or not? because it is not performing what i want it to perform
the tables structure are as follows
distinctfiller has one attribute checkinks(text)
distictlinks has one attribute precrawl(text)
just tell this query is the valid or not
Re: sql query problem
Posted: Mon Jun 07, 2010 8:08 am
by altafhussain
always sub queries written in () brackets so wrote in brackets ()
Re: sql query problem
Posted: Mon Jun 07, 2010 8:12 am
by mayanktalwar1988
yup its working