• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu

Left Outer Join problem

Started by Skip, November 11, 2013, 03:55:45 PM

Previous topic - Next topic

Skip

Hi All -

I am trying to make a left outer join work.  All that I have tried in the past works
perfectly but this one.  What diifers is that one column is defined as integer
and the column trying to match is defined as the default.  The data if fine
in each table and there are no nulls present.  It simply is 2 different column
definitions being used for the left outer join on clause.  Should that present a
problem?

Thanks in advance -

Skip

Skip

Dear All -

I found my problem to the left outer join.  A chr$( 1 ) was inserted ( ie programmer bug ) in the 1st
position of one of my sequnce numbers.  That caused the mismatch.

However, I'm stiil curious whether it is ok to mix data types when using the join on clause.

Skip