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 <[EMAIL PROTECTED]> 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. _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor