SitePoint Sponsor

User Tag List

Results 1 to 25 of 25

Threaded View

  1. #1
    SitePoint Wizard PHPycho's Avatar
    Join Date
    Dec 2005
    Posts
    1,201
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Perfect INNER JOIN query on multiple tables

    Hello forums!!

    I have some questionaire regarding INNER JOIN among multiple tables.
    I always got confused about where to start (which table) & then which table thereby in case of multiple tables.

    I have screenshot of ERD attached, I think relation between them is obvious as picture worths more than thousands of words. I want to perform the INNER JOIN query on this.
    I would like to know the which table to start with and then which table(moreover perfect inner join query) , I mean to say like this:
    Code MySQL:
    SELECT
    *
    FROM
    ?1
    INNER JOIN ?2 ON ...
    INNER JOIN ?3 ON ...
    ...so

    Can somebody make perfect INNER JOIN query on those table ( attached ERD)?
    Thanks
    Attached Images Attached Images


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •