view table conditions

[Former Member]

Hello Gurus,

For creating a view I am trying to join 2 tables.

I have selected 4 fields in first table and 3 fields in the second table.

The join condition is in such a way that the first table field(not primary) is input to second table primary field.

The first table field is of 10 char length and the input field in the second table primary field is 70 characters in length.

When we take the value in the first table field individually and give input in the second table it works. I.e., it works individually.

But when this data is seen using the view it doens't show any records, since the field length condition is not met.

Any solution on this.

Regards

Mac

[Former Member]

Hi,

the values of the two fields which you are trying to put in join condition are same in the both the tables,

check the entries in both the tables and specially for the fields you are putting a join,,

if the data does not match it will never give you results

Regards,

Siddarth

[Former Member]

Hi,

In the join condition try delimiting the lenght of 70 character field.

Hope this might help.

Regards,

Kritesh Shah

[Former Member]

Hi,

How can I delimit the length of 70 characters to 10 in the join conditions of the view.

Regards

mac

[shahid_malayil1]

Hi Mac,

Check out this one

Best regards,

Shahid Malayil

[Former Member]

Solved myself