Re: abstraction of table relationships

Cimode wrote:
> [snip]
> Select * from Books --> Authorship --> Persons where PersonId = 'Steven King';
> Select * from Books --> Editorship --> Persons where PersonId = 'John Doe';
> [snip]

I like this syntax. Might it follow that I could ask:

select * from books --> authorship, editorship --> person_id = "jog"

...to determine books either edited or authored by me. Or even:

select * from books --> ALL --> person_id = "jog"

...to determine books with which I have any role of involvement with at all, as specified by foreign key reference clauses? Received on Thu Sep 07 2006 - 19:25:48 CEST