select * from tbl_SPL_Stages s where ownerId = and ownerType = SELECT * from qmd_stages WHERE stateCode = 'O' SELECT * from qmd_stages WHERE stateCode = 'C' SELECT * from qmd_stages WHERE stateCode = 'R' SELECT * from qmd_stages WHERE stateCode = 'K'