SQL en Crystal Reports

[dvd_m_s]

Saludos estoy trabajando en Vstudio 2005 y tengo la necesidad de generar un reporte, el query es :

Código:

select d.name,C.name, A.Time 
from ArticleFootPrintTable as A, ArticlexTable as B, articletable as C,desktable as d,baskettable as e
where A.articleid = B.ArticleId
and A.articleId = C.Id
and A.actionid=8 
and A.basketid in ( 38,46,54,33,70,141,85,244,86,101,102,206,17,117,456,118, 133)
and d.id=e.deskid
and e.id=a.basketid
and B.EditionId= 1297
order by d.name ,A.time desc

cual es el sql equivalente en Cristal Reports?

Gracias