[Tutor] Re: DB design
cyresse at gmail.com
Tue Feb 15 11:57:11 CET 2005
Ack, sorry, just found the advanced tutorial and 'joins'.
(Also wondering if I spelt embarrassed right.)
On Tue, 15 Feb 2005 23:26:06 +1300, Liam Clarke <cyresse at gmail.com> wrote:
> 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.
> 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.
More information about the Tutor