1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Help for join Expression

Discussion in 'C#' started by mbm2000, Jul 20, 2009.

0
  1. #1
    Hi
    I'm using join Expression to select data from two tables , One for categories
    And the other for subcategories.
    But when i show the records each subcategory arrives next to category.
    Example:
    Category name(s) : Cars ,Announcements
    Sub categories name(s) For cars : Audi, Chevrolet, Geo
    Sub categories name(s) For Announcements : Announcements-General , New Business.
    When I show the records It looks like this:
    cars >> Audi cars >> Chevrolet cars >> Geo
    Announcements >> Announcements-General Announcements >> New Business
    ==========
    I need to show my records like this:

    cars >> Audi , Chevrolet , Geo
    Announcements >> Announcements-General , New Business
    ==========
    Commas are not important

    Note: I'm using ASP3 (classic) With VBscripts Language and My db is access
     
    mbm2000, Jul 20, 2009 IP
  2. mbm2000

    mbm2000 Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Isn't there any one to answer my question?
     
    mbm2000, Jul 22, 2009 IP
  3. f7d.master

    f7d.master Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    display your data table structure.
     
    f7d.master, Jul 23, 2009 IP
  4. mbm2000

    mbm2000 Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    please describe more.
    I don't know any thing of structure
    thanks
     
    mbm2000, Jul 24, 2009 IP
  5. mbm2000

    mbm2000 Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    please help......
     
    mbm2000, Jul 25, 2009 IP
  6. EmeraldOne

    EmeraldOne Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Please provide the table structure that you have..
    Do you have two or three tables??
    What is the relation with them??
    Provide all related tables..

    Isaac,
    http://www.7Live7.com
     
    EmeraldOne, Jul 25, 2009 IP
  7. mbm2000

    mbm2000 Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Hi
    I have two related table call Categories and Subcategories.
     
    mbm2000, Jul 25, 2009 IP
  8. certifications4you

    certifications4you Peon

    Messages:
    32
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #8
    please give more details about your table structure....
     
    certifications4you, Jul 28, 2009 IP