topic Joining two tables having no common fields using one select query in Application Development and Automation Discussions

Joining two tables having no common fields using one select query

former_member590333 — Fri, 05 Sep 2014 09:33:20 GMT

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.

Re: Joining two tables having no common fields using one select query

Former Member — Fri, 05 Sep 2014 09:35:25 GMT

What do you mean?

If you want to do a join they should have some common fields

Max

Re: Joining two tables having no common fields using one select query

ThomasZloch — Fri, 05 Sep 2014 09:38:05 GMT

This is only possible in the Nth dimension, please see the online documentation for joins using the LEFT OUTER SPACE syntax.

Thomas

Re: Joining two tables having no common fields using one select query

RaymondGiuseppi — Fri, 05 Sep 2014 09:46:26 GMT

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

Re: Joining two tables having no common fields using one select query

Former Member — Fri, 05 Sep 2014 10:02:28 GMT

It might help us to help you, if you define what tables you are talking about (assuming they aren't custom Z tables.)

Cheers,

Re: Joining two tables having no common fields using one select query

former_member590333 — Fri, 05 Sep 2014 10:22:38 GMT

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

Re: Joining two tables having no common fields using one select query

Former Member — Fri, 05 Sep 2014 10:36:20 GMT

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

Re: Joining two tables having no common fields using one select query

Former Member — Fri, 05 Sep 2014 10:38:59 GMT

Yes as Raymond says

You need to do a join between three tables, the third table has to be used as link

Max