Hi,
I have problem with join and order clause. I have 2 table join with
amount condition and sort by order clause. The result of this join
generate unwanted row to me.
example
table1
No. Amount Count
1 1000 2
2 2000 3
3 500 1
table2
No. Name Amount
1 A 1000
2 B 2000
3 C 2000
4 D 1000
5 E 500
6 F 2000
sql=select * from table1,table2 where table1.amount=table2.amount order by
table2.amount desc,table2.no
result table
no name amount count
2 B 2000 3
2 B 2000 3
3 C 2000 3
3 C 2000 3
6 C 2000 3
6 C 2000 3
1 A 1000 2
1 A 1000 2
4 D 1000 2
4 D 1000 2
5 E 500 1
5 E 500 1
If I did not use order by table2.no in sql it generate result correctly.
SF
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
