I have a select statement that is not returning rows of data or an error message. Is there a different way to write the statement?
This command: bro * from stfmbrlicense where StfMbrDscplRecno in (Select StfMbrDscplRecno from StfMbrDiscipline) returns several rows of data. This command: SELECT t1.StfMbrDscplRecno, t1.RgstrtnStatusRecno, t2.StfMbrDscplRecno, t2.StfMbr, t2.Discipline FROM StfMbrLicense t1, StfMbrDiscipline t2 where t1.StfMbrDscplRecno = t2.StfMbrDscplRecno Returns no rows of data.
