Crystal,
thank you very much
It works perfectly!
Valentino
Da: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Inviato: domenica 28 ottobre 2018 07:32
A: MS_Access_Professionals@yahoogroups.com
Oggetto: Re: [MS_AccessPros] query when there are record that differ for capital letter
the full SQL would be:
SELECT aptbstr01.code, aptbstr02.code
FROM aptbstr01, aptbstr02
WHERE StrComp(aptbstr01.code, aptbstr02.code, 0) = 0
~crystal
On 10/27/2018 5:30 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:
you're welcome,
instead of linking with a join line, you could match records using criteria. For example:
WHERE StrComp(aptbstr01.code, aptbstr02.code, 0) = 0
respectfully,
crystal
Unicode Character Map -- free tool in Access
http://msaccessgurus.com/tool/UnicodeCharMap.htmOn 10/27/2018 1:55 PM, Valentino Avvisati valentino.avvisati@gmail.com [MS_Access_Professionals] wrote:
Thank you Crystal,
my problema is that I need to link some table using this field and I have non clear how I can do the inner join between the two tables, it is possible have an example how have the query below but case sensitive?
SELECT aptbstr01.code, aptbstr02.code
FROM aptbstr01 INNER JOIN aptbstr02 ON aptbstr01.code = aptbstr02.code
Valentino
Il giorno 27 ott 2018, alle ore 16:44, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> ha scritto:SELECT aptbstr01.code, aptbstr02.code
FROM aptbstr01 INNER JOIN aptbstr02 ON aptbstr01.code = aptbstr02.code;
I get a result of 4 record because for
Posted by: "Gmail" <valentino.avvisati@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar