> What's wrong in the following sql query?
>
>

SELECT spomast.matcode, partmast.DESCRIPT, spomast.spono, procmast.DESCRIPTIO, ;
> 	spomast.sporate, spomast.maincode FROM spomast inner JOIN accmst ON spomast.maincode = accmst.maincode ;
> 	inner JOIN procmast oN spomast.proccode = procmast.proccode ;
> 	inner JOIN partmast ON spomast.matcode = partmast.partno where spomast.maincode = '136S05'

>
> with this query no records are selected - where as if "where" clause is removed all records are selected.
>
> Ulhas Amrite

Is the maincode field size 6. If it is more then is exact off.

Regards
Tushar