Thanks on answers.

Objects is user table, 2008/ portion is arbitrary,

as well as 1449 is arbitrary starting point.

I am not sure if I can use this, since I have 10000...

I think I explained very detailed what I need in one of my posts.

Please check and let me know if anything missing in my second explanation:

First, db1 has:

SELECT ObjectID,...

First, db1 has:

SELECT ObjectID, Media, artist, place, gender from db1.view1

Example:

1, paint, Arthur, Europe, male;

2, paint, John, US, male;

3, wood, Ann, Europe, female;

Second, db2 has:

SELECT CustomData.Field_ID, CustomData.Record_ID, FieldDef.Name,

...

Thank you Sean,

I will make it clearer.

I don't have actual DLL, I have data/query, will try to be more clear in next post/reply on this issue.

One more issue with this specific query, which gave me headache is:

- db1 has record like this:

record_id, column1, column2, column3, column4.

- db2 has record like this:

record_id, column_id (based on...

The way they explained it actually worked.

The only (kinda strange) behavior is if you try to save as a view:

It will give you some error; After, view result is good.

Opening...

Thanks Sean, will do,

Brano

Thanks Sean,

I will work on this one :-)!

Regards,

Brano

Thanks toddasd for comments, and I will do simplification.

It took some times :-), but here is example:

CREATE TABLE table1

(

key1 int,

connected_column varchar(255),

DataId varchar(255),

)

INSERT INTO table1

(key1, connected_column, DataId)

VALUES

(1, 'id1', 'test'),

(2, 'id2', 'test'),

(3, 'id2', 'test'),

(4, 'id2', 'test'),

(5, 'id3', 'test'),

(6, 'id3', 'test'),

(7,...

And new data are:

IdCode2 DataId

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

233cond11

074cond22

074cond22

074cond22

074cond22

074cond22

074cond22

074cond22

074cond22

074cond22

175cond33

175cond33

175cond33

175cond33

175cond33

175cond33

175cond33

175cond33

276cond11

276cond11

276cond11

276cond11

276cond11

276cond11

276cond11

276cond11

377cond22

377cond22

377cond22

377cond22

377cond22

377cond22

Where id is connection between tables.

Hi john,

I tried (actually, I tested it first) next:

UPDATE table1

SET table1.DataId =

...

Thank you,

I solved with CASE statement.

I must ask one more question:

How to use CASE statement (or similar, maybe if?),

because it is not just Update, it is based on data from table2 another values in table1.

Thank you guys, will try, after I match this with my tables :-).