SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Sub query!!

  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2001
    Location
    Rawalpindi, Pakistan
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello!
    how can we use sub query something like

    select * from tab1 where id = (select max(id1) from tab2);

    Thanx

    Aatif Malik

  2. #2
    SitePoint Wizard
    Join Date
    Jul 1999
    Location
    Chicago
    Posts
    2,629
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    As of recently, in MySQL, yes you can. But if you're writing an app that will go on others' servers as well as your's...don't use them. For more information, check Google's results.

    You'll see freddiedoesphp using them quite a bit (he's our "resident PHP expert").


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
  •