>- see footer for list info -< Hi, I would like some help to understand why one of my query simply doesn't work. It doesn't return any error message but doesn't do what I want to get.
I have two tables with one (table1) an exhaustive list of articles and one (table2) with some articles which needs to be eliminated of my selection under certain criteria. All articles in table 2 are included in table1 (but not vis versa) What I am looking to obtain is all the articles in table1 which are not in table2. In order to do that I am using in my query the following syntax in the condition: WHERE table1.article<>table2.article I run some tests and I notice that the system simply seems to ignore the filter. Thank for any one who can help me to understand where is my mistake. Lauriane _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
