SQL like statement?

[Cojack]

Hi Access users,



Can you help me out?
I would to connect/compare two tabels.

Tabel 1
Field: Groupname
(example: ACROBAT)

Tabel 2
Field: Groupname
Status: Status
(example: X231-ACROBAT-10E8; finished)

Query Result: (ACROBAT; finished)

Would it be possible to connect these tabels with a "like" and wildcards statement? And give me the correct result?

i'm not formiliar with VB in Access to hopefully it possible without it?

the Query should be something like this??????

SELECT Tabel1.GroupName
FROM Tabel1
INNER JOIN Tabel2
ON Tabel1.GroupName like "*"&Tabel2.GroupName&"*";

[NoellaG]

Hi,

you can't use the "like" operator in the join expression. You can though use functions in it: for instance
[field1] = iif(instr([field2],"ACROBAT"),"ACROBAT").
Be carefull, this slows the query down quite a bit.

grNG

[weekend00]

Another way, you may try this:

SELECT Tabel1.GroupName,table2.status
FROM Tabel1,table2
where Tabel1.GroupName like "*"&Tabel2.GroupName&"*" group by table1.groupname,table2.status

[NTC]

From your post it is not clear to me that you need to involve table 1, if table 2's status includes the group name.

Based on what you posted all you really need is to make a select query of table 2 and put in your criteria with wild cards:

(example: X231-ACROBAT-10E8; finished)

Query Result: (ACROBAT; finished)

critieria: like "*Acrobat*finished"

but not sure I fully understand your goal. Hope this helps.

[Cojack]

Another way, you may try this:

SELECT Tabel1.GroupName,table2.status
FROM Tabel1,table2
where Tabel1.GroupName like "*"&Tabel2.GroupName&"*" group by table1.groupname,table2.status

Thank you very much, this solved my issue

Regards,