table join

[Former Member]

can we extract data from two tables without having common field between those two ?

[Sougata]

in that case why JOIN them??

[Former Member]

Hi

No,

How can you extract data from the 2 tables without having any field common? means there should be some link between them, then only we can get the related data?

other wise what's the use of getting data from another, if it is not linked to first table.

Reward points if useful

Regards

Anji

[Former Member]

Well how can you extract data without any fields not common between them..

In one case you can do the same....

if you want data from the two tables which are not related...

Regards,

Jayant

[Former Member]

Hi Srinu,

You need to find a table which has can be linked to these tables then you can inner join three of them to get your data.

Regards,

Younus

Reward Helpful Answers!!!!

[Former Member]

Hi Srinu,

No, U can't join two tables if they are not having any field common.

means there should be some link between them, then only you can get the related data?

reward points if helpful.

Regards,

Hemant

[Former Member]

Hi,

U can join two tables without link, but, it will give cartesian product means each entry of other table will be shown for each entry of first table.

Generally it is not recommended, anyway, if u can elaborate ur requirement then we may try to find out some way.

Jogdand M B