aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Collumn names in sql request" Watch "Collumn names in sql request" New topic
Author

Collumn names in sql request

Sergey Shantor
Greenhorn

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
Bartender

Joined: Dec 20, 2006
Posts: 2510
    
  10

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
youtube channel
darq Arq
Greenhorn

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


1011011001
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Collumn names in sql request