RE: [GENERAL] Relations between tables.

On 20 May 99, at 13:01, Jackson, DeJuan wrote:

> > Being rather new to DBs in general, I wonder - is the relation

<snip>

> > Using a relation constraint, are tables tied together automatically,
> > thus removing the need to use a 'WHERE table1.index = table2.t1index' in
> > select clauses retreiving data in table2 and table1?

You can essentially achive this by creating a view, and then
selecting against the view, rather than the individual tables within it.

> Nope this doesn't even happen in MS Access. If you build your query in
> Access and look at the SQL (go to the View menu the select SQL) that's
> generated you'll see that all Access is put that part of the WHERE clause
> in for you. Most other databases aren't that presumptuous.
>
> > christian
> -DEJ
>
>
>