473,320 Members | 2,133 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

fetching data from many tables

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
1 1412
patjones
931 Expert 512MB
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

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

Similar topics

7
by: Good Man | last post by:
Hi there I'm in the planning stages of creating a database, and I have two options here. Which makes more sense, and/or provides better performance for queries - a single table with hundreds of...
1
by: narayana | last post by:
how to know about how many tables i created in that database.if the database is connected to many users. i want the query in this way that i want creater,number of tables,time,updates . the...
2
by: narasingarao | last post by:
Hi to group, I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project period here i have to migrate the MS-Access database table to Oracle data base tables...so, please help me in getting...
4
by: Dirk Olbertz | last post by:
Hi there, I'm currently about to redesign a database which you could compare with a database for managing a library. Now this solution will not only manage one library, but 100 to 500 of them....
7
by: Emin | last post by:
Dear experts, If I have a number of related groups of data (e.g., stock prices for different stocks) is it better to put them into many tables (e.g., one table per stock) or into one big table...
1
by: mcasaurabhsumit | last post by:
hello friend, how many tables a dataset can store at a time? can u tell me.
1
by: zoro25 | last post by:
Hi, Maybe my question is dumb, but I'm not sure what is the best approach. I need to build a report and the data is stored in many tables and queries (8 or 9) and I'm wondering if I should build...
5
by: davec4 | last post by:
I am a new Access use and need to concatenate (UNION) many tables. I am currently doing it "by hand": SELECT * FROM UNION SELECT * FROM ; UNION SELECT * FROM ; ..... UNION SELECT * FROM...
2
TheServant
by: TheServant | last post by:
Hi everybody, I posted a similar question about 6~12 months ago with no definate answer, so I will give it another go, as the choice has popped up again in my programming life: If the number of...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.