Hi!
Sorry for my missing..
select
t1.userId,
t1.standartId,
t2.userId
from
tasks as t1
left join
tasks as t2
using(standartId)
where
t1.userId='jimmy'
I think it should work.
Saturday, April 24, 2004, 5:12:56 PM, Jimmy wrote:
JB> I'm using MS SQL Server 2000 and I have a
Hi!
Try this:
select
t1.id,
t1.standartId,
t2.id
from
tasks as t1
left join
tasks as t2
using(standartId)
where
t1.id='jimmy'
Saturday, April 24, 2004, 5:12:56 PM, Jimmy wrote:
JB> I'm using MS SQL Server 2000 and I have a table called tasks with the
JB> following schema:
