A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Collumn names in sql request
Joined: Jan 19, 2010
Feb 09, 2010 02:35:23
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
FROM ... INNER JOIN ADDRESS ON ...
P.S.Sorry for my english if made any mistakes.
Joined: Dec 20, 2006
Feb 11, 2010 00:31:48
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?
OCUP UML fundamental and ITIL foundation
Joined: Feb 11, 2010
Feb 11, 2010 00:59:02
make trhe question clear.. we'l help you
It is sorta covered in the
JavaRanch Style Guide
subject: Collumn names in sql request
resolving many to many relatiionship
many to many jpa saving example
JPA mapping/ERD advice
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014