ah ok, thanks for the help larry. ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, December 02, 2004 11:29 AM Subject: [RBASE-L] - Re: Propper SQL
> > yeah districtno is text, unfortunately we have some districtno's that are > > "10306C" so we have it as a text 7. > > In that case TEXT is the correct data type. > > > in the locations table we have a bunch of locations for different districts > > but district '67959' might have locno '010' and district '10306C' might also > > have locno '010' so we are qualifying by districtno on both tables so 67959 > > users dont see the location description from 10306C (its happened in the > > past and it confused some people hehe). > > I don't need to tell you that you have a structural problem with the data, in > that case. However, it might be clearer if you did: > > WHERE tranmaster.districtno = '67959' + > AND tranmaster.locno = location.locno + > AND tranmaster.districtno = location.districtno > > -- > Larry >
