Let me start off by saying this isn't a perl question as such but I hope you'll indulge me

Simple question: can all SQL JOIN statements be expressed either as JOINs or WHERE syntax? In other words, is the syntax "INNER JOIN ON foo = bar" unique, and can do things that can't be done any other way, or is it just a Tim-Toady kind of expression of the same thing?

This all started with my desire to make a database for a TV show here with proper normalisation of what's a kind of three-dimensional structure.

So now I have a table of people, a table of roles and a table of episodes, and a fourth table with three numeric columns, which contains the information that in episode n, person n plays role n.

So in order to find out who plays which role in episode one, I can (thanks to Jeffa) do this: 


    SELECT people.firstname, people.lastname, role.name
    FROM roles
    INNER JOIN eps_people_roles
        ON 
        roles.id = eps_people_roles.role
            INNER JOIN people
                ON 
                eps_people_roles.person = people.id 
    WHERE 
        eps_people_roles.ep = 1

[download]

but unless I'm completely crazy, I can also do this: 



    SELECT 
        people.firstname, people.lastname,  role.name
    FROM people, roles, eps_people_roles
    WHERE (
            roles.id = eps_people_roles.role
              AND
            eps_people_roles.person = people.id
          )
    AND eps_people_roles.ep = 1

[download]

which seems to give the same results. I'm asking, to be honest, because I just like that second kind of syntax better. 


($_='kkvvttuubbooppuuiiffssqqffssmmiibbddllffss')
 =~y~b-v~a-z~s;                             print

[download]

In reply to SQL JOINs vs WHERE statements by Cody Pendant

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.