Post reply

select Like!

  • October 17, 2005 at 3:36 pm

    #111099

    need to select siteid  from site table compare ing the sitedescription  with the desc in other test table.

    tried in but not getting full result! what is the otherway to do!!

     

    Thanks

  • October 17, 2005 at 4:57 pm

    #597795

    Without your table schema, relationships, data, and desired result it is extremely difficult to help you.

    Please post what your tables, relationships, and sample data.

    http://www.aspfaq.com/etiquette.asp?id=5006

     

  • October 18, 2005 at 7:07 am

    #597915

    the relationship is not that complicated. It is just data in the site table with site id. and testtable with site discription but the discription in testtable is not exactly in site table: such as:

    Site id = 128

    Desc(in Site Table) = SMX SW Boca Ranton

    but in TestTable:

    Desc: Boca Ranton.

    so need to create query that will pick up the site id from SiteTable by comparing the Desc in both table. I tried IN but thhe desc like above doesn't work with IN.

    Thanks

     

     

  • October 18, 2005 at 9:08 am

    #597960

    I would say that it would be more appropriate to define your site description table with a siteID foreign key to be more explicit. In pattern matching, on a join you will not get the desired results.

    I do not know of any way to do it reliably

  • October 18, 2005 at 9:10 am

    #597961

    Yeah, but the that table is created on fly by excel file and they have only that to get the site number from database to check wethere the users are in right locatoin of the site. by using site description in both table!!

    thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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