[Tutor] Re: DB design

[Liam Clarke]

Ack, sorry, just found the advanced tutorial and 'joins'. 
Sorry.

*embarrassed*

(Also wondering if I spelt embarrassed right.)


Regards, 

Liam Clarke

On Tue, 15 Feb 2005 23:26:06 +1300, Liam Clarke <cyresse at gmail.com> wrote:
> Hi,
> 
> Working my way through the basics of SQL, and I can see that it's very
> powerful for searching by different criteria.
> 
> I'm already hitting my conceptual troubles however, as I'm visualising
> each table as a 'card'.
> Always my problems, too much imagination. But yeah, it seems very 1
> dimensional. But what I was wondering was is it possible within the
> bounds of SQL to contain a SQL query reference as a value, so that
> retrieving a certain value retrieves the results of that query i.e.
> 
> table foo
> 
> a b c
> 
> 1  2 select d from bar
> 
> table bar
> 
> d e f
> 
> 3 4 5
> 
> and select c from foo retrieves d from bar? I know I'm leapfrogging
> way ahead of myself, and probably confusing myself unnecessarily, but
> I'm just trying to make my cards more 3D in terms of linking data....
> 
> Any assistance for my vague question gratefully appreciated.
> 
> Regards,
> 
> Liam Clarke
> 
> --
> 'There is only one basic human right, and that is to do as you damn well please.
> And with it comes the only basic human duty, to take the consequences.
> 


-- 
'There is only one basic human right, and that is to do as you damn well please.
And with it comes the only basic human duty, to take the consequences.