Re: Navigation question

On 2007-03-03, Bob Badour wrote:

>> You are issuing multiple independent queries with (hopefully)
>> increasingly defined parameters. There is no connection between them,
>> other than some shared parameters. Even in an SQL DBMS, you *cannot*
>> "navigate" around tables.

Still, presume you went for maximal selectiveness on each query: you'd query on the primary key. Suppose you did this for each foreign key value on another table, without any intervening user input or program logic. Then your client software would be reimplementing a join on the two tables, in a manner I'd call "navigational".

-- 
Sampo Syreeni, aka decoy - mailto:decoy_at_iki.fi, tel:+358-50-5756111
student/math+cs/helsinki university, http://www.iki.fi/~decoy/front
openpgp: 050985C2/025E D175 ABE5 027C 9494 EEB0 E090 8BA9 0509 85C2