The following code works and goes to the screen SELECT control#,transdate,model#,sortoneoh,remainqtyoh, + partnum,partpcspt,numpart,assypcsae + FROM ((topenorders t1 + INNER JOIN orderrows t2 ON t1.control# = t2.control#) J1 + INNER JOIN prodpart t3 ON j1.model# = t3.model#) J2 + INNER JOIN assy_part t4 ON j2.partnum = t4.assembly# + WHERE sortoneoh IN (ad,bl,br,lr,fp,ot,pb,pc,pt,sp) + AND remainqtyoh > 0 AND packlistpt='Y'
However When I try to insert that info directly into a table, I get an error. INSERT INTO tmodprod (control#,transdate,model#,sortone,remainqty, + partnumpp,partpcs,partnumap,assypcs) + SELECT control#,transdate,model#,sortoneoh,remainqtyoh, + partnum,partpcspt,numpart,assypcsae + FROM ((topenorders t1 + INNER JOIN orderrows t2 ON t1.control# = t2.control#) J1 + INNER JOIN prodpart t3 ON j1.model# = t3.model#) J2 + INNER JOIN assy_part t4 ON j2.partnum = t4.assembly# + WHERE sortoneoh IN (ad,bl,br,lr,fp,ot,pb,pc,pt,sp) + AND remainqtyoh > 0 AND packlistpt='Y' This is the error. Tmodprod is a real temp table already created. So am I wrong in trying to INSERT using the INNER JOIN code? [cid:[email protected]] James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB33948E5608EBBA00E571733FA0C20%40CY4PR0201MB3394.namprd02.prod.outlook.com.
