Re: [MS_AccessPros] query when there are record that differ for capital letter

 

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: Valentino Avvisati <valentino.avvisati@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___