On 18 Jan 2005 11:09:51 -0800,
sd********@msn.com wrote:
Select LOCGeneralHave.LSCH, LOCSubClassHave.LSCH from LOCGeneralHave ,
LOCSubClassHave Where (LOCGeneralHave.LCNT <> '0' and
LOCSubClassHave.LCNT = '0')
This query seems to be ignoring the 'and' part of the clause.
Basically I want select from table1, table2 where LCNT in table1 is not
0 and
LCNT in table2 is 0.
I have verified the LCNT's numbers
This query returns 2 columns with 1700 rows
It needs to only find a few rows.
What am I missing, any ideas, thanks for any help.
Hi sdowney,
Awfully hard to tell without knowing anything about your tables, data and
expected results. Please post your table structure (as CREATE TABLE
statements, including all constraints but excluding irrelevant columns), a
few rows of sample data (as INSERT statements) and the expected output
based on that sample data. Describe the rationale as well.
Check out this site for more info on how to post:
www.aspfaq.com/5006.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)