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
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)