Join command help [message #374562] |
Mon, 18 June 2001 18:39 |
JXM
Messages: 6 Registered: June 2001
|
Junior Member |
|
|
I need to find a way to get queries from 3 similar tables for the same date (a field) and print out the fields the 3 tables have in common?
Thanks,
JXM
|
|
|
Re: Join command help [message #374575 is a reply to message #374562] |
Tue, 19 June 2001 12:22 |
Sudhakar Atmakuru
Messages: 58 Registered: May 2001
|
Member |
|
|
I only suggest you to alias them for those three
common fields and use the alias names to print
them out. I could help you if you would give more
details of it since it is not clear what you want
to achieve from what.
|
|
|
Re: Join command help [message #374576 is a reply to message #374562] |
Tue, 19 June 2001 12:26 |
Sudhakar Atmakuru
Messages: 58 Registered: May 2001
|
Member |
|
|
I only suggest you to alias them for those three
common fields and use the alias names to print
them out. I could help you if you would give more
details of it since it is not clear what you want
to achieve from what.
|
|
|
Re: Join command help [message #374617 is a reply to message #374575] |
Thu, 21 June 2001 12:29 |
JXM
Messages: 6 Registered: June 2001
|
Junior Member |
|
|
What I am trying to do is this:
I have 3 tables, and I need to select rows from them and group them by type from another table (not in any of these). Then I want to find the sum of those items by date and print it out. I have to embed all of this into C++. I hope I have described my problem better.
Thanks
|
|
|