Hi!

I have 2 tables... named acc_categroies and wnd_categories both have 1 field named categories...

i need to get all data from both tables then sort them and display how can i do this in 1 go ?

currenntly i use 2 sql queries to get the data from 2 tables..! and order it like this:

"select category from acc_categroies order by category" then another query

"select category from wnd_categories order by category"

now the problem is the data is dsiplayed liek:

A-Z for first tables then A-Z for second table.

Instead it should be A_Z for both tables!