CROSS JOIN

[Carlos]

I'm trying to do a cross join of 2 tables and it always
gives me an error that says "command not properly ended".
Can anybody tell me what is the correct way to formulate such a
join? I've been looking on the web for some time and I can't
find an answer for this.

[DaveSatz]

select l.name, u.*
from sysusers u
CROSS JOIN master..syslogins l

CROSS JOIN
Specifies the cross-product of two tables. Returns the same rows as if no
WHERE clause was specified in an old-style, non-SQL-92-style join.

--
Thanks,
David Satz
Principal Software Engineer
Hyperion Solutions
->Using SQL Server 7.0 SP2/6.5 SP5a/Cold Fusion 4.5.1/ADO 2.1/VB 6.0/MTS
(Please reply to group only)
-----------------------------------------------------------------

"Carlos" <carlos@ans.net> wrote in message news:3a2800d5$1@news.devx.com...
>
> I'm trying to do a cross join of 2 tables and it always
> gives me an error that says "command not properly ended".
> Can anybody tell me what is the correct way to formulate such a
> join? I've been looking on the web for some time and I can't
> find an answer for this.