Search results

  1. M

    Select Query

    Hi, I have dept no separated with comma in a string str1 and a table of deptno Table named as 'dept' and field as deptno .I want to search the string str1 in table dept and get the deptno that does n't exist in table dept . Thanks Md.Matiullah
  2. M

    Update query with Select statement

    Table PR has multiple records on same primary key P.I .I want to update P.HMD with count of PR.I on specified condition . I am getting this error. Operation must be an updatable query. Access query is given below. UPDATE P INNER JOIN PR ON P.I=PR.I SET P.HMD = (SELECT COUNT(PR.I) FROM PR WHERE...
  3. M

    Update query with Inner join

    Hi, I have two tables named DOH1 and Alignment , want to update DOH1.whse_nbr based on condition DOH1.STORE_NBR=ALIGNMENT.STORE_NBR AND DOH1.WHSE_TYPE=ALIGNMENT.WHSE_TYPE I am writing this query using Inner join UPDATE DOH1 INNER JOIN ALIGNMENT ON (DOH1.STORE_NBR=ALIGNMENT.STORE_NBR AND...
Back
Top Bottom