I was wondering if anyone know how to perform a database search(query) by matching specified number of colums (not all columns) to intersect with another query and at the same time get the data that doesnt intersect.

What database are you using? In PostgeSQL, you could do exactly what you posted and it would work, but in MySQL it gets way complicated. This sort of thing totally depends on which database you are using. -localfilmmaker Spencer Christensen