Incorrect Syantax

Hi,
I am trying to use the following statement inmy trigger; but I am getting
error "incorrect syntax near ',' .
IF (@.CompanyOrderNo,@.Status NOT IN ( SELECT COMPANY_OrderNO,Status_ID from
OrderStatus))
How to correct this?
Thanks
pmudIF ( SELECT count(*) from OrderStatus
where COMPANY_OrderNO = @.CompanyOrderNo and Status_ID=@.Status ) = 0
"pmud" wrote:

> Hi,
> I am trying to use the following statement inmy trigger; but I am getting
> error "incorrect syntax near ',' .
>
> IF (@.CompanyOrderNo,@.Status NOT IN ( SELECT COMPANY_OrderNO,Status_ID fr
om
> OrderStatus))
> How to correct this?
> Thanks
> --
> pmud|||This works... Thanks!
--
pmud
"tthrone" wrote:
> IF ( SELECT count(*) from OrderStatus
> where COMPANY_OrderNO = @.CompanyOrderNo and Status_ID=@.Status ) = 0
> "pmud" wrote:
>