How can i compare smallint and int

Vaibhav Vyas · #1 (**permalink**) 07-01-09, 09:37

hi

In source i have smallint data type and in destination i have integer data type..

So how i can compare that?

Thanks in Advance !!

r937 · #2 (**permalink**) 07-01-09, 10:00

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

Vaibhav Vyas · #3 (**permalink**) 07-01-09, 10:09

hahi Thanks for this...

But up to i know we can't use where clause just after the ON ..

If i am wrong please let me know.

stolze · #4 (**permalink**) 07-01-09, 10:19

Rudy posted regular standard SQL. So what do you mean with "you can't use a WHERE clause after the ON"? The ON ... is part of a joined table. A joined table is part of the FROM clause, and following the FROM clause may come a WHERE clause. So the ON and the WHERE are actually not related at all and orthogonal concepts.