Charlie, Try
SELECT t1.StfMbrDscplRecno, t1.RgstrtnStatusRecno, t2.StfMbrDscplRecno, t2.StfMbr, t2.Discipline FROM StfMbrLicense t1 + INNER JOIN StfMbrDiscipline t2 on t1.StfMbrDscplRecno = t2.StfMbrDscplRecno just make sure that column names are properly spelled and correctly associated with t1 and t2 references Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 > >From: Charles Parks <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Mon, January 3, 2011 4:52:25 PM >Subject: [RBASE-L] - Select statement > > >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. >
