Results 1 to 2 of 2

Thread: SQL JOIN syntax

  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Unanswered: SQL JOIN syntax

    ISSUE IS SOLVED

    -----------------

    I think this is an easy one...I need help with the 'JOIN' statement (or the appropriate statement to connect data from two tables).

    I have the following separate statements that work to get me the data I want from each of the two separate tables.

    From the ads table:

    SELECT DISTINCT id , school
    FROM ads

    From the cb table:

    SELECT title, link FROM cb

    I want to connect the two when the column 'id' that is in the ads table = the column cb_id that is in the cb table.

    Any help here?

    Thanks

    -------

    ISSUE IS SOLVED
    Last edited by dweb77; 09-05-11 at 15:33.

  2. #2
    Join Date
    Mar 2011
    Posts
    4

    Sql joining

    You may solve your problem with sql inner joining. You can follow this link Sql inner join - SQL tutorials | w3resource

Posting Permissions

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