* dan orlic
> INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
> category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
> + g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
> as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
> now() as
dan orlic wrote:
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
+ g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
now() as