USE LIKE in join

[sal21]

Code: Select all

SELECT RAPP.S, RAPP.C, *
FROM BU INNER JOIN RAPP ON BU.NOM = LIKE * RAPP.INT *;

In need to join with like operator this sql in Access, but have error

[HansV]

Try

Code: Select all

SELECT RAPP.S, RAPP.C, BU.*
FROM BU INNER JOIN RAPP ON BU.NOM LIKE "*" & RAPP.INT & "*";

[sal21]

Try

Code: Select all

SELECT RAPP.S, RAPP.C, BU.*
FROM BU INNER JOIN RAPP ON BU.NOM LIKE "*" & RAPP.INT & "*";

work perfect!