[thelist] SQL Multiple entries in same column?

[Rob Keniger]

on 14/11/00 3:54 PM, Adrian Fischer at adrian at logo-logic.com wrote:

> I'm hollering...
> I need to understand this more fully.  At the moment I am doing multiple
> selects from different tables and I know I should be able to use the one
> statement to retrieve from both tables.  Its been a case of making it work,
> but not efficiently.  Its not just the theory that I need to polish up on
> its also the implementation.  I have just about read the mySQL documentation
> from front to back but am still none the wiser :-(
> I think I don't understand the relationship of Unique and Foreign keys and
> how they impact on what I'm trying to do.
> 
> Laymen's terms would be just fine...(more than fine, or a link)

Sounds like you need SQL tutorials:

http://w3.one.net/~jhoffman/sqltut.htm  (the original and the best)

http://www.sqlcourse.com/   (with nice interactive sql examples)

http://www.sqlcourse2.com/

-- 
 
Rob Keniger

big bang solutions

<mailto:rob at bigbang.net.au>
<http://www.bigbang.net.au>