syntax problem

[hyy1109]

The following gives syntax error. Why? Thanks.

SELECT *
FROM LeaseLOS
WHERE (WellID IN (select wellid from wells where leaseid in (38, 40))

 

[Mr3Putt]

This is, almost assuredly, not the cause... nor the cure, but try:

SELECT *
FROM LeaseLOS as L
WHERE (L.WellID IN (select w.wellid from wells as w where w.leaseid in (38, 40))

As said, that's probably not it, but you may be suffering from ambiguous references to both "leasid" and "wellid".

[red]Note:[/red] [gray]The above comments are the opinionated ravings of Mr3Putt. As such, Mr3Putt accepts no responsibility for damages, real or contrived, resulting from acceptance of his opinions as fact.[/gray]

 

[mrdenny]

You are missing a ) from the end.

SELECT     *
FROM         LeaseLOS
WHERE     (WellID IN (select wellid from wells where leaseid in (38, 40))[COLOR=red])[/color]

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[hyy1109]

Added ) and it is working now. Thanks.

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)