[CrazyTn]

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

[CrazyTn]

nm it was simpler than I though it would be.

[Frunkie]

Sometimes actually "doing it" to find out, many times tells the answer