• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

MySQL Order by question

O

Oblivion|MC

n00b
Joined
Jul 4, 2001
Messages
45
Hey everyone,
thanks for looking

I've been doing some minor mysql coding for a few month, but have encountered a problem i cant quit figure out.

I have two tables
TABLE1
1.....3
2.....5
3.....3
4.....5
5.....3

TABLE2
1.....A
2.....B
3.....C
4.....D
5.....E

My problem is this
I want to select * from table2 i would like it to be ordered by table1's numbers.. alittle confusings.. but lets assume table1 has their categories inside
i want to select all from table2 but first list all that have 3... and then that have 5...

so final should display
1.. A
3.. C
5.. E
2.. B
4.. D

any suggestions would be helpful.
thanks!
 
you join the initial columns, then order by table 1 column 2, table 2 column 2
 
You must log in or register to reply here.
Back
Top