topic Re: table join in Application Development and Automation Discussions

table join

Former Member — Mon, 14 May 2007 07:11:25 GMT

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

Re: table join

Sougata — Mon, 14 May 2007 07:13:40 GMT

in that case why JOIN them??

Re: table join

Former Member — Mon, 14 May 2007 07:14:46 GMT

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

Re: table join

Former Member — Mon, 14 May 2007 07:15:36 GMT

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

Re: table join

Former Member — Mon, 14 May 2007 07:20:02 GMT

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!!!!

Re: table join

Former Member — Mon, 14 May 2007 07:20:36 GMT

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

Re: table join

Former Member — Mon, 14 May 2007 07:35:40 GMT

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