Subject | problem with query |
---|---|
Author | allan |
Post date | 2002-07-01T03:55:52Z |
Hi,
I am building a query in a table and i am having a trouble sorting of data. here's my query
select a.quantity * b.value as product
from table a, table b
where a.my_code = b.my_code
order by a.quantity * b.value desc
how can i execute the query???
_____________________________________________
www.bahayKO.com ~ my Filipino Homepage!
11.9 cents to the Philippines, Intant Phone Card via EMAIL!
https://www.bahayko.com/cgi-bin/misc/frames.cgi?item=LUCK10
Going home for vacation? Book your travel arrangements with us� send us an email at travel@... and get a quote!
I am building a query in a table and i am having a trouble sorting of data. here's my query
select a.quantity * b.value as product
from table a, table b
where a.my_code = b.my_code
order by a.quantity * b.value desc
how can i execute the query???
_____________________________________________
www.bahayKO.com ~ my Filipino Homepage!
11.9 cents to the Philippines, Intant Phone Card via EMAIL!
https://www.bahayko.com/cgi-bin/misc/frames.cgi?item=LUCK10
Going home for vacation? Book your travel arrangements with us� send us an email at travel@... and get a quote!