Hello,


I have two table, table1 contain 2 fields ([filename], [filepath])

Table2 contain 1 field ([keyword])

Now I want to make a simple query,from table 1 and [keyword] field from
table2 as a criteria of [filename] for this query, also criteria as a new
field returned by this query. I mean query contain 3 fields [filename],
[filepath], criteria of filename([keyword])

Thanks in advanced.

Masoud -

SELECT filename, filepath, keyword
FROM Table1 INNER JOIN Table2 on Table1.filename = Table2.keyword;

--
Daryl S


"Masoud" wrote:

> Hello,
>
>
> I have two table, table1 contain 2 fields ([filename], [filepath])
>
> Table2 contain 1 field ([keyword])
>
> Now I want to make a simple query,from table 1 and [keyword] field from
> table2 as a criteria of [filename] for this query, also criteria as a new
> field returned by this query. I mean query contain 3 fields [filename],
> [filepath], criteria of filename([keyword])
>
> Thanks in advanced.
>

thank you very much, it works, i wanted not excatly the same value so i used:

SELECT table1.filename, table1.filepath, table2.keyword
FROM table1, table2
WHERE (((table1.filename) Like "*" & [Table2]![keyword] & "*"));
and works now.

"Marshall Barton" wrote:

> Masoud wrote:
> >I have two table, table1 contain 2 fields ([filename], [filepath])
> >
> >Table2 contain 1 field ([keyword])
> >
> >Now I want to make a simple query,from table 1 and [keyword] field from
> >table2 as a criteria of [filename] for this query, also criteria as a new
> >field returned by this query. I mean query contain 3 fields [filename],
> >[filepath], criteria of filename([keyword])
> >
>
> You can get all combinations of file stuff and keywords by
> using:
>
> SELECT [filename], [filepath], [keyword]
> FROM table1, table2
>
> but I don't understand how you want to use keyword as a
> filename criteria. If you want to find filrnames that are
> the same as a keyword, then use:
>
> WHERE [filename] = [keyword]
>
> --
> Marsh
> MVP [MS Access]
> .
>