syntax quessie
i have a table ID,description,somecode (1,000 records)
I create a second table grouped on ID, descr,0 as noLines from table 1 (50 records)
I want to update table2.noLines withe the count from table1 where table1.somecode = 2, joined on id
i have a table ID,description,somecode (1,000 records)
I create a second table grouped on ID, descr,0 as noLines from table 1 (50 records)
I want to update table2.noLines withe the count from table1 where table1.somecode = 2, joined on id
Comment