Adding a Pseudo year field

[#1]

Hi All,

    I am having the following sceario

Table A

YEAR,FLAG

2012,Y

2013,N

Table B

TAX,INFO

xx,yy

dd,mm

Table C

ID,Details

xx,abc

dd,jjj

From the above tables,even though I dont have any common key field between Table A & B I need to create a Pseudo column of Year in Table B,Then I need to make a relationship to the table C.

All I want to know ,here how to create a Pseudo Year field with the Table B based on Table A

-Jay

[alexandros17]

Table B

TAX,INFO

xx,yy

dd,mm

left join

select distinct year as year from Table A

in this way all records for table B will have all yhe years in table A

Hope it helps

[#3]

Hi,

  Thanks for your quick response. If I do the Left Join I can have the year in Table A but,there is no Key field between those. In my real time data it will slow down my Reloading process. So obviouslly I need to create a link of Year field in Table B

-Jay

[alexandros17]

The join is Table B left join Table A, in this way you will add the field year as previously descripted.

Let me know ...

[#5]

Hi Alexandros17,

  Thanks again for your quick response. I hope am not clear in my scenario.The Table B dont have any Year field with it. So even though if we do the Left join it will force the Year field to Table B from A. But the reload time,Object retrival time will be high in my dashboard then. So instead of  simply doing the Left Join I need to create a Pseudo Year Field to make a perfect relationship.

-Jay