By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 971 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

fetching data from many tables

P: 1
hey guyz could u please help me 2 get a particular data from many tables in database without specifying the table name in query...

for example..

i have marks database with table english, tamil, maths etc.. i want to select particular student mark from all tables without specifying the table name..

if u have any idea post it sooooooooooooooon...
Sep 29 '11 #1
Share this Question
Share on Google+
1 Reply


patjones
Expert 100+
P: 931
This is one of the most poorly posted questions I've ever seen in my time working with this site.

With that said, I'm going to tell you that this is not possible. The FROM clause is a basic and required part of any SQL query.

If you want to pursue the issue further, please ask your question using proper grammar and capitalization and explain why you don't want to use any table names in your query.

Pat
Sep 30 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.