It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Collumn names in sql request Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Collumn names in sql request" Watch "Collumn names in sql request" New topic

Collumn names in sql request

Sergey Shantor

Joined: Jan 19, 2010
Posts: 3
The problem is next:
if I have to many-to-many relations and both of them directing to the same table, for example COMPANY and EMPLOYEE have the same table as ADDRESS,

how can I "single out" each address_company and address_emploуe using

SELECT address_company, address_emploуe FROM ... INNER JOIN ADDRESS ON ...

P.S.Sorry for my english if made any mistakes.
Jan Cumps

Joined: Dec 20, 2006
Posts: 2562

Hi Sergey,

we can probably help you, but you will have to make your question easier to understand.

Can you tell us which tables you try to join,
and an example of data in the tables, and how you want to show the results?

Regards, Jan

OCUP UML fundamental and ITIL foundation
darq Arq

Joined: Feb 11, 2010
Posts: 2
make trhe question clear.. we'l help you

I agree. Here's the link:
subject: Collumn names in sql request
It's not a secret anymore!