Code:
SELECT lbname, imgname
FROM lightbox LB
INNER JOIN lightboxcoll LBC on LB.ID = LBC.LBID
WHERE LBC.ID IN (SELECT TOP 3 ID FROM lighboxcoll LB1 WHERE LB1.lbid=LB.ID)
ili primer za Northwind koji provereno radi
Code:
select * from employees e
inner join orders o on e.employeeid = o.employeeid
where o.orderid in (select top 3 orderid from orders where employeeid = e.employeeid)
order by e.employeeid
[Ovu poruku je menjao jablan dana 14.03.2006. u 14:38 GMT+1]