InfoSet Join condition

[Former Member]

Hi gurus!

We have an InfoSet joining 2 ODS's bye bill number and position. It's a simple join whitout any filter or condition but when we check data there are records missing. If we look at the SQL query there is a where clause and we don´t know why. Here you have the SQL:

select

N'0000' AS , .[BILL_NUM] AS , .[BILL_ITEM] AS , COUNT( * ) AS

FROM

JOIN

ON

.[BATCH] = .[AU_VHCLE]

AND ( ( ( ( ( ( (.[AU_DYIS] IS NULL ) ) OR ( ( .[AU_DYIS]= N'0000' ) ) ) ) ) )

)

GROUP BY

.[AU_DYIS],[T00002].[BILL_NUM],[T00002].[BILL_ITEM]

ORDER BY

ASC, ASC, ASC

what is AU_DYIS doing there??? we have never done anything with AU_DYIS on the IS definition!!

Thanks guys!

[Former Member]

Hi martin,

If you used simple join in Infoset that means you have used Inner join. Inner join will give only those record which are commen in both the ODS.

Take Example..

ODS1 having Bill number A , B

ODS2 having Bill number B, C

then output of inner join infoset is only B.

you can't get A & C.

Hopefully this will solve your Query.

Regards,

[Former Member]

Thanks! but I know how INNER JOIN works. May be I was not clear enough...

the problem is why the SQL query has a where clause if we've never specified that?

[Former Member]

what means N'0000' on SELECT sentence??? I do not see that on query result...

[Former Member]

what means N'0000' on SELECT sentence??? I do not see that on query result...