CODEWITHSUNDEEP
sqlms-accessms-access-2010
Mohit
Mohit

Reputation: 69

Access Query need to pick parameters from another Table at run time

I need to delete and append the data from a Access Table ULAE. I want to create a parameter query where parameter needs to be picked from another table LAE. This table has 3 columns(Group,le,qtr) that will be an input and will be part of where condition.

I am trying to run the query:

DELETE FROM t_00_unearned_unincepted_alloc_basis_table as ULAE
INNER JOIN [Table Valued Parameter] as LAE
ON LAE.le=ULAE.le;

It shows the error that specify the input table you want to delete.

Thanks in advance.

Upvotes: 0

Views: 667

Answers (1)

Sathish
Sathish

Reputation: 4487

Try like this

DELETE  ULAE.*
FROM t_00_unearned_unincepted_alloc_basis_table as ULAE
WHERE ULAE.le IN (SELECT le FROM LAE where le= parametervalue)

Upvotes: 1

Related Questions