ms access query

umeshtheone · May 31st, 2007, 11:24 PM

hi

we have to table named "tmpteacher" and "tmpteacher1" .we have to get record which is not common in both table.the query which we trying is :

SELECT tmpteacher1.* FROM tmpteacher INNER JOIN tmpteacher1 ON (tmpteacher.tc<> tmpteacher1.tc);

for = to condition its working.for <> not working .
we are running this query in ms access .

Please suggest possible answer:(

BrianWren · June 1st, 2007, 10:27 AM

Try

Code:

SELECT tmpteacher1.*  
FROM   tmpteacher1 
WHERE  tmpteacher1.tc NOT IN (SELECT DISTINCT tmpteacher.tc
                              FROM   tmpteacher)

Joins really are for showing as one result set the columns from more than one data source (table, query, etc.)

In your case, you are trying to limit the records from one table according to the relationship of that tableâs data to the data in a different table.