Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Search:

Type: Posts; User: smoseley

Search: Search took 0.09 seconds.

  1. Replies
    6
    Views
    1,979

    SQL doesn't care about relationships on SELECTs. ...

    SQL doesn't care about relationships on SELECTs. Only on INSERTs. It's called referential integrity. A student_class can't reference a student_id that doesn't exist, so it won't let you insert a...
  2. Replies
    6
    Views
    1,979

    Also, if you want to return a record from one...

    Also, if you want to return a record from one table even if there are no records in the related table, consider using LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

    LEFT returns records from the...
  3. Replies
    6
    Views
    1,979

    Well that's the standard that I've always used......

    Well that's the standard that I've always used... it is generally accepted as the way to go.

    Also, regarding:

    INNER JOIN students AS s ON classes.id = sc.student_id

    I meant to say:

    INNER...
  4. Replies
    6
    Views
    1,979

    SQL is not an intuitive language. It will not...

    SQL is not an intuitive language. It will not allow you to select from a table unless you specify it in your FROM list.

    Additionally, your database is not relational. Relational implies an...
Results 1 to 4 of 4
All times are GMT -6. The time now is 05:35 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com