Kevin
Fri Mar 05 15:39:48 CST 2004
Hi Stu,
You use the same type of JOIN. The way a JOIN works is that the result of
the JOIN is a result set, which, in a SQL Query, is equivalent to a table.
You can then JOIN that result set to another table. In a sense, you are
using nested JOINs in the same SQL Statement. You may want to use the Access
Query Designer to help you work out the syntax.
--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Stu" <anonymous@discussions.microsoft.com> wrote in message
news:7b3b01c402f3$69c89cc0$a501280a@phx.gbl...
> That works great with 2-tables using "INNER JOIN".
> Now my final question. What type of join is used if there
> are 3-tables??
>
> >-----Original Message-----
> >Use a JOIN query.
> >
> >--
> >HTH,
> >Kevin Spencer
> >..Net Developer
> >Microsoft MVP
> >Big things are made up
> >of lots of little things.
> >
> ><anonymous@discussions.microsoft.com> wrote in message
> >news:4f6801c402de$1e393f40$a601280a@phx.gbl...
> >> Sngle, I guess. Page includes a search form. Only
> >> displays 4-5 fields but would like to add another field
> >> from a different table within the same database.
> >> >-----Original Message-----
> >> >In a single result set? In multiple result sets? What?
> >> >
> >> >--
> >> >HTH,
> >> >Kevin Spencer
> >> >..Net Developer
> >> >Microsoft MVP
> >> >Big things are made up
> >> >of lots of little things.
> >> >
> >> >"Stu" <sarmstrong@townfin.com> wrote in message
> >> >news:4f0e01c402d8$dc3663c0$a601280a@phx.gbl...
> >> >> Have Result pages to display Access database fields.
> >> Works
> >> >> fine, but I wondered how to display fields from more
> >> than
> >> >> one table???
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >