질문하기

The Cougar Kid's profile - activity

2015-09-25 13:49:41 +0200 받은 배지  정리의 달인
2014-05-04 09:54:17 +0200 받은 배지  유명한 질문 (source)
2014-01-11 07:08:34 +0200 받은 배지  주목할 만한 질문 (source)
2014-01-09 23:13:59 +0200 받은 배지  인기있는 질문 (source)
2014-01-07 22:43:11 +0200 받은 배지  학생 (source)
2014-01-07 12:44:00 +0200 질문하였습니다 Joining text fields in Base

I am trying to convert an ACCESS database to BASE; I have used ACCESS for many years, but this is my first try with Base. One key thing I need to do is a simple join on two tables - one of them in fact a view - on a text field - the person's name in fact. I am doing this in SQL with this query: SELECT "results"."date", "concatenate names"."id", "results"."score", "results"."section" FROM "concatenate names", "results" WHERE "concatenate names"."name" = "results"."player1" The entries in the 'player1' field in the 'results' table comprise 21 different values, all of which are present amongst the 300 entries in the 'name' field in 'concatenate names' yet this query produces zero rows; the spellings, spacings, etc are identical. Why? The database operates around the (numeric) 'id' field (as in 'concatenate names') but unfortunately this value is not available in the 'results' table, which comes from an external source.