Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Collumn names in sql request

 
Sergey Shantor
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
darq Arq
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
make trhe question clear.. we'l help you
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic