SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: table joins...

  1. #1
    SitePoint Addict user_A's Avatar
    Join Date
    Mar 2004
    Location
    Vancouver, BC
    Posts
    218
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    table joins...

    Question: I already did an inner join in mySQL, now when i want to query these tables using PHP, do i have have to query them using joins, or can i query one table, but that table is already joined to a another table using INNER JOIN, within mySQL????

    Thanks

  2. #2
    Tranceoholic lilleman's Avatar
    Join Date
    Feb 2004
    Location
    Írebro, Sweden
    Posts
    2,716
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    No, I don't think it can be done automatically. You'll have to specify the join in your query.
    ERIK RIKLUND :: Yes, I've been gone quite a while.

  3. #3
    Chessplayer kleineme's Avatar
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    608
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    starting with MySQL 5 you can create views
    Never ascribe to malice,
    that which can be explained by incompetence.
    Your code should not look unmaintainable, just be that way.


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
  •