Post reply

sql query problem a simple one

  • July 4, 2005 at 6:09 am

    #570625

    No chance .

  • July 4, 2005 at 6:38 am

    #570629

    You are welcome. BTW the query I used was Remi's I just created some tables that would match. I had come to the same conclusions but type much much slower than he does. (Probably think slower as well but I am not going there)

    Mike

  • July 4, 2005 at 6:42 am

    #570631

    If you have a bad case of the twiches when you get back from vacation. Its your own fault from not getting a laptop so you could stay in the loop.

    enjoy

    Mike

  • July 4, 2005 at 6:44 am

    #570632

    I have a pc at home... will probabely pop in once in a while . But I have other plans for those weeks.

  • July 4, 2005 at 6:46 am

    #570633

    "I had come to the same conclusions but type much much slower than he does. (Probably think slower as well but I am not going there)"

    Don't sell yourself short, I don't even type 100 words/minute. But I do think rather fast .

  • July 4, 2005 at 7:01 am

    #570638

    i have not tested your query, becoz iam at different location dont have databse to check

    iam talking about my query

     

    suppose a candidates registers, his registration details will be stored in candidatesregmst

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 4, 2005 at 7:04 am

    #570640

    When you post the ddl and sample data we'll be able to help you. Good luck until then.

  • July 4, 2005 at 7:15 am

    #570644

    You have a pc at home how odd. You sound like my son who probably does type a 100 words per min. But where he gets his real speed as he says is in using keyboard short cuts. After showing me something at the speed of light he sits back and says see dad how easy it is. I just pat him on the back and ask to move so a caveman can get to the keyboard and beat the problem to death with his trusty on club.

    Sneaking back home for just a few min to play on the computer does not work. Been there done that and ended up cutting the grass and edging the drive before I could sneak back out.

    Mike

  • July 7, 2005 at 2:48 am

    #571680

    this will do the job, even in MSAccess I think.

    select fname from candidatesmst

    where not exists(select * from resumelist where resumelist.candiid= candidatesmst.candiid

    )

    I think it will work, because it is Standard SQL, but not tested. Good luck

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply