select s.cCode as SegItemCode, S.cDescription as SegItemDesc,* from Accounts a 
	left join _etblGLSegment S on A.iGLSegment1ID = S.idSegment
	WHERE S.idSegment is null