www.webdeveloper.com
Results 1 to 4 of 4

Thread: sub queries question

Threaded View

  1. #1
    Join Date
    May 2010
    Posts
    137

    sub queries question

    I am trying to study sub queries, but correlated sub queries is not yet clear to me. Suppose I have users_tbl that have id and user_name column, I also have login_tbl that have id and last_login columns. How can I join the two table,getting the user_name and last_login using sub query? I know how to do this with join. Like this below

    SELECT u.user_username, d.date_time_in
    FROM users_tbl
    JOIN last_login d ON u.user_id = d.user_id

    But how to do this using sub query instead?
    Last edited by anishgiri; 01-13-2013 at 10:58 PM.

Thread Information

Users Browsing this Thread

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

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