Click to See Complete Forum and Search --> : Left Join


queezer
05-04-2006, 07:17 PM
Hi,

I'd like to get some help on this: I'm working on SAS but with SQL Statements. I have Table A with about 1000 rows and Table B has about 500 rows. None of the 2 tables have repetition in the column that I want to join. The problem is that I'm expecting to get 1000 rows using left join but instead of that i get about 1200 rows. How is that possible? Specially considering that this final table don't have repetions!.. I need some help plz...

Thank you

chazzy
05-04-2006, 08:07 PM
joins will match where matches shouldn't happen. you might have to add a condition like
AND TABLEA.SOME_COLUMN IS NOT NULL