Quote:
|
Originally Posted by Vaibhav Vyas
So how i can compare that?
|
Code:
SELECT ...
FROM source
INNER
JOIN destination
ON destination.somecolumn = source.comecolumn
WHERE source.smallintcolumn = destination.integercolumn
the WHERE clause will evaluate as TRUE or FALSE depending on whether the comparison is equal or not equal
this query will therefore return all matching rows where they are equal
