Where clause from join of table

[quartex]

Hi,

I have two tables :

the main table to replicate

with Idkey and other value

and a table joined (with multiple value idkey / idcountry) with a idkey and a valid field with 1 value if a row from main table is to syncronize.

Is it possible in synch where clause (no from table i present …..) use multiple table ?

[Shadow]

Hope I got your questin right: you want to sync the main table, but only those rows which are 'valid' and the validity are determined in another table.

In this case the answer is no, you cannot use columns from another table (no FROM clause…). In this case, however, you could move the 'valid' field to your main table.

[Author]

Posts