Posted by Jeffrey Sheldon via SQLMonster.com on 08/17/05 21:04

Razan,

THANK YOU, this did it

Jeff

Razvan Socol wrote:
>Try this:
>
>SELECT X.* FROM (
> select DISTINCT a.project_id
> from project as a, project_cost_element as b
> where a.project_id = b.project_id
> and a.project_status in ('T','A')
> and b.cost_element_id between '7012000' and '7012999'
>) X CROSS JOIN (
> SELECT 1 N UNION SELECT 2 UNION SELECT 3 UNION SELECT 4
>) Y
>
>Razvan


--
Message posted via http://www.sqlmonster.com

• Next in forum: Re: One table link breaks every time
• Prev in forum: ROWTERMINATOR in bulk insert query.
• Thread view: Re: Tripling end results of a query

[Reply to this message]