select different data from 20 tables

[sujasundaran]

Hi,
i need to select different data from 20 differnt table. whta is the best way of doing this?
X

[Anon]

As far as there is relationship between the tables, you can apply the query that you use for two or three .. tables ....

[Anon]

You can:

1. Query them all separately
2. Join them in one query
3. Use a union over them all

If you really have no idea which of these to use, I really think you should go and read a book on databases...

Chris