I have a query like below. I don’t understand the difference between join
vs inner join
used on the below code. Aren’t they the same? This is written for Sybase
. Please help me know the difference.
SELECT count(distinct c.stuID ) as cnt FROM tableC c Inner Join tableB b On c.otherID = b.otherID Inner Join tableX gd On b.otherID = gd.otherID Inner Join tableY g On gd.groupID = g.GROUPID and g.GROUPTYPEID in ( 1, 3 ) JOIN tableZ d on c.OPID = d.OPID JOIN tableM e on c.OTHERID = e.otherID and c.stuID = e.stuID and DATEDIFF(..........)
Advertisement
Answer
According to the standard INNER JOIN=JOIN. I think, Sybase does not break this rule