sql query with != condition not working
my query is
Select regno from member_master where parentregnoM=2 and parentPosM=1 and registerAS != 'Free'
not giving me any result
but when i write the query like
Select regno from member_master where parentregnoM=2 and parentPosM=1
show me right result
where in registerAS field values are null so first query also shows the results