質問する

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.