[SOLVED] Query after plan activation and data from a table

Hi team, how are you ?
I want to know, in CBSubs, how can I build an insert query which have some ata comps from me or cb fields, and others comes from a table.

ex
insert into #__test (a, b, c)

but a is a custom value : "test"
b is a values which comes from a table
c is a cb field

So, a and c I understand but b ?????

Can anybody help me please ?

Regards

Myann

You can use select queries inside of insert queries. You can also use substitutions in the query when used in CBSubs SQL Actions. Example as follows.

Below should also work.

Hi, I used the second method!! it works

Great

Myann