Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    24

    Unanswered: Order by two tables

    I am not sure if this is even possible.

    Table A:
    1. name - String

    Table B:
    1. name - String
    2. order - int

    foreign key between the two name.
    I want to order the content of Table A by using Table B order.

    Example:
    Table A:
    1. Bob
    2. Mike

    Table B:
    1. Bob order 3
    2. Mike order 1
    3. Sam order 2

    If I would to select all the contents from table A it would come out.
    1. Mike
    2. Bob

  2. #2
    Join Date
    May 2007
    Posts
    24
    nm it was simpler than I though it would be.

  3. #3
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    Sometimes actually "doing it" to find out, many times tells the answer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •