Re: Query Creates Read-Only Recordset

How about something like this:

DELETE tblChildRecords.SomeName, tblChildRecords.SomeNumber,
tblChildRecords.IDField
FROM tblChildRecords
WHERE (((tblChildRecords.SomeName) In (SELECT item FROM tblParent WHERE
ID<10));

Just us the IN clause and specify a valid subselect...

.

Relevant Pages

  • Re: How do the records retrieve from data base when using sql statements?
    ... Just use an order by clause. ... guaranteed to be returned in the correct order in you don't specify an order ... SQL statement. ... This means that the keys are located continuously and every "insert" ...
    (comp.sys.ibm.as400.misc)
  • Re: BLOCK CONTAINS
    ... program that does not have the BLOCK CONTAINS clause. ... specify the BLOCK CONTAINS clause, because it has no meaning to VSAM). ... "It is not mandatory to code DCB parameters in JCL while creating new QSAM ... There are three source for DCB information, Program, JCL, and File Label, ...
    (comp.lang.cobol)
  • Re: [Newbie] Strange output from list
    ... No matter how many columns you specify in the ... SELECT clause, each result row is a tuple. ... string representation of the entire row (which mimics a Python tuple, ...
    (comp.lang.python)
  • Re: BLOCK CONTAINS
    ... Either is a perfectly valid default according to the COBOL standard. ... BLOCK would be the default consistent with VSAM handling. ... program that does not have the BLOCK CONTAINS clause. ... care) I can't see any reason to ever specify the BLOCK CONTAINS clause. ...
    (bit.listserv.ibm-main)
  • Re: Create table and default order by clause
    ... by" clause to use when no "order by" clause is specified in a "select" query ... the only way to guarantee result order is to specify ORDER BY in the SELECT statement that selects from the table. ... Note that it is likely, but not guaranteed, that you will get results ordered in sequence by the table's clustered index in a trivial query with no joins or where clause. ...
    (comp.databases.ms-sqlserver)