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