www.webdeveloper.com
Results 1 to 2 of 2

Thread: Problem with SQL Statement

Hybrid View

  1. #1
    Join Date
    Jan 2010
    Location
    IN
    Posts
    29

    Problem with SQL Statement

    Hi guys,

    I have one problem,

    Table A (contains 100 records), just one identifier
    Table B (contains 500 records), just two identifiers

    What i want is, there must be a SQL statement....which offer me

    It must take first record from TABLE A, and check that into Table B...if exists then display that records there. and the show must continue till 100 records (till Tables moves to end)

    Plz help me finding such statement i can execute as SQL statement.

    many thanks in advance.

  2. #2
    Join Date
    Sep 2008
    Posts
    33
    select tablea.col1 from tablea left join tableb on tablea.col1 = tableb.col1 WHERE tableb.col2 IS NOT NULL;

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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



Recent Articles