hi this is raju and i am using ms-acess database in dotnet and please help

Question

0.00/5 (No votes)

See more:

i have created three table table1 BookingDetails,table2 Customerdetails,table3 booking, i want to get the details from table2 and table3 ...in all tables customerid is common....
and the details in the table3 are saved with the id's not name....example towerid ,flatid and i need tower name and flat name...and these are stored in another two tables table4 towermaster,table5 flat master,and in this there is no customerid...only towerid and flatid...how its possible it will possible are not??

thnk q

Posted 12-Sep-12 20:00pm

rajushyamu7

Updated 12-Sep-12 20:02pm

Kuthuparakkal

v2

Add a Solution

Comments

Kuthuparakkal 13-Sep-12 2:02am

Learn SQL Join

_Amy 13-Sep-12 2:31am

:thumbsup: I could have given you +5 for this comment. :)

rajushyamu7 13-Sep-12 5:17am

thank you.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-09-12T21:08:00

Solution 1

As suggested, you need a JOIN statement:

Get name from other table:

Alias has AKAName and ActorID
Actors has Name and Id

SQL

SELECT a.Name, b.AKAName
 FROM Actors a JOIN Alias b ON a.Id = b.ActorId

Posted 12-Sep-12 21:08pm

OriginalGriff