Missing columns in Join From table.

Larry Beasley ●

The list on the left is predicated on the datatypes available in the table on the right. To prove this I created a virtual table with the sql:

select 1 col1, '3435' col2, cast('12/13/2013' as datetime) col3

Then, I joined from one of the tables that has datetime/timestamp columns. Went back into the virtual table and removed the datetime column(col3) and the list of available columns to join from was reduced by the number of datetime/timestamp fields. I'm not sure how picky this is, e.g. VARCHAR(10) => VARCHAR(20) or VARCHAR() vs. NVARCHAR(). Actually, I just tested that and it is not that picky.

The list on the left is predicated on the datatypes available in the table on the right. To prove this I created a virtual table with the sql:

select 1 col1, '3435' col2, cast('12/13/2013' as datetime) col3

Then, I joined from one of the tables that has datetime/timestamp columns. Went back into the virtual table and removed the datetime column(col3) and the list of available columns to join from was reduced by the number of datetime/timestamp fields. I'm not sure how picky this is, e.g. VARCHAR(10) => VARCHAR(20) or VARCHAR() vs. NVARCHAR(). Actually, I just tested that and it is not that picky.

Reply URL

2

Pratap Singh ●

Hi Larry,

Thanks for your reply,

Don't know but how this happened but when I have removed the table from query builder and reinserted it, now I am able to see all the columns.

Regards

Partap

URL

2

Larry Beasley ●

Wonderful news! All is well again in your world! Have a great day!

URL

2

Mark McGuire ●

Hi Pratap,

I am pleased all is well, it's good to see our community members helping each other. Can you confirm this is all resolved?

Larry - Thank you for the input, we really appreciate users helping here in the community.

Regards,

Mark

Reply URL

Missing columns in Join From table.

Replies (2)