09-05-2014 10:33 AM
Hi Experts,
How to join two tables which are NOT having any field in common using only one select query?
Your help will be appreciated.
Thank you.
09-05-2014 10:35 AM
Hi
What do you mean?
If you want to do a join they should have some common fields
Max
09-05-2014 10:38 AM
This is only possible in the Nth dimension, please see the online documentation for joins using the LEFT OUTER SPACE syntax.
Thomas
09-05-2014 10:46 AM
Identify a third table (or more tables) with common fields with your two tables, or change your question either removing JOIN or removing NO COMMON FIELDS, else you wont get many responses and will be left alone in outer space, as suggested by Thomas.
If you acturally require what you written, better execute two select and merge the two internal tables merging every record from first table with every record of second table, til no more memory is available.
Regards,
Raymond
09-05-2014 11:22 AM
Hi Raymond,
Does that mean I need to identify third table having common fields from both the tables and then performing join of those three tables in single select query?
Thank you.
Regards,
Prajakta
09-05-2014 11:38 AM
Yes as Raymond says
You need to do a join between three tables, the third table has to be used as link
Max
09-05-2014 11:02 AM
It might help us to help you, if you define what tables you are talking about (assuming they aren't custom Z tables.)
Cheers,
G.
09-05-2014 11:36 AM
Hi,
If None of the fields are Common in Table , Then it would not be feasible to use Join (Left Or Right)
1. If You want data in single Row then
Instead You may loop your Table and modify Fields of other table
2. If You want to Append data then
you may use Appending Clause with Select Query .
Regards