Query

[simran]

Hi everyone,
When i execute this query i get the following error

SELECT action.action_time,
company.company,
person.fname,
person.nickname,
person.lname,
action.actiontype,
sorttime = case action_time when NULL then 1 else 0 end ,
Completed = case action.cdate when NULL then 0 else 1 end ,
action.actionid , convert(varchar(20), action_time,114) sorttime
FROM person, company , action
WHERE action.pid =* person.pid and
action.tdate >= :tdate and
action.tdate < dateadd(day,1,:tdate) and
action.responsibility = :viewcbid and
action.coid=company.coid


Error
The table &#39;action&#39; is an inner member of an outer join clause. This is not allowed if the table also participates in a regular join clause.

What should I do?
Thanks

i&#39;m not familiar with this syntax.
is this tsql?

>= :tdate

looks like oracle?

------------
simran at 2/29/00 1:30:35 PM

Hi everyone,
When i execute this query i get the following error

SELECT action.action_time,
company.company,
person.fname,
person.nickname,
person.lname,
action.actiontype,
sorttime = case action_time when NULL then 1 else 0 end ,
Completed = case action.cdate when NULL then 0 else 1 end ,
action.actionid , convert(varchar(20), action_time,114) sorttime
FROM person, company , action
WHERE action.pid =* person.pid and
action.tdate >= :tdate and
action.tdate < dateadd(day,1,:tdate) and
action.responsibility = :viewcbid and
action.coid=company.coid


Error
The table &#39;action&#39; is an inner member of an outer join clause. This is not allowed if the table also participates in a regular join clause.

What should I do?
Thanks