want a nested query

[sangi]

hello,
iam in need of a nested query.
i have nearly 6 tables which have a field called "purchasenumber".
all the tables have the same field name and its the form of
"A/THI/001"
i want to find the maximum number from all the tables
plz do help me
bye
sangi

 

[mymou]

I think you could use nested queries - but they normally hurt my head.

Look into union queries.

select purchasenumber
from table1

union select purchasenumber
from table2

union select purchasenumber
from table3


Stew