SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    933
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    SELECT 2 tables, proper syntax?

    Before anything else I"m using MyISAM since my hosting don't support InnoDB.

    I have two tables that has columns,

    1st table: users_swap
    and the columns are
    Code:
    usid,
    us_id,
    swap_id
    
    note: us_id came from 'users' table.
    2nd table: swap
    and the columns are
    Code:
    swap_id,
    date_posted,
    offering,
    seeking
    I want to SELECT swap_id and offering columns from swap table.
    Using a specific user_id from users_swap table

    I hope I explained it clearly.
    So what is the right SELECT syntax?

    Thank you very very much in advanced.

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,494
    Mentioned
    161 Post(s)
    Tagged
    4 Thread(s)


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
  •