1 reputation
12
bio website
location
age
visits member for 2 years, 9 months
seen Dec 22 '11 at 16:21

Jun
23
awarded  Notable Question
May
6
awarded  Popular Question
Dec
22
comment Joining two tables on multiple criteria
it works swimmingly. Thanks a lot!
Dec
22
revised Joining two tables on multiple criteria
added 134 characters in body
Dec
22
awarded  Editor
Dec
22
revised Joining two tables on multiple criteria
added 1208 characters in body
Dec
21
comment Joining two tables on multiple criteria
I tried: SELECT * FROM positions pos INNER JOIN products pro ON COALESCE(pos.criterium1, pos.criterium2,'') = COALESCE( pro.criterium1, pro.criterium2,'') but this does not match pro.criterium1 to pos.criterium1 or pro.criterium2 to pos.criterium2
Dec
21
asked Joining two tables on multiple criteria