Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question about a query result
Message
From
10/05/2004 11:17:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Question about a query result
Miscellaneous
Thread ID:
00902445
Message ID:
00902445
Views:
61
Hi, i'd like to know how can i made a query where i can bring the same amount of records even when the join doesn't apply?

In this query:
select 	llamadas.numero				as numero		,;
		llamadas.fllamada 			as fllamada		,;
		llamadas.undhard 			as hardware		,;
		llamadas.modelo 			as modelo		,;
		llamadas.mantenim 			as sernombre	,;
		llamadas.host	 			as host			,;
		llamadas.piso				as piso			,;
		llamadas.usuario			as usuario		,;
		llamadas.ingeniero			as ingeniero    ,;
		llamadas.grupo				as grupo	    ,;
		llamadas.servicio			as servicio	    ,;
		llamadas.reporta   			as usunombre	,;
		oficina.nombre				as ofinombre	,;
		dispositivo.descripcion 	as disnombre	,;
		ingeniero.nombre			as ingnombre	,;
		grupos_ing.nombre			as grunombre	,;
		sub_unidades.descripcion 	as mantenim		,;
		" "  						as llaestado18	,;
		" "  						as llaestado18	,;
		" "  						as llaestado18	,;
	    llamadas.fcierre			as cierre 		,;
	    llamadas.frepuesto			as frepuesto	;
	from	llamadas, usuarios_cia, oficina, dispositivo, ingeniero, grupos_ing, sub_unidades ;
	where 	Sys(11,Llamadas.fasignacion) >= sys(11,m.ini) and;
            Sys(11,Llamadas.fasignacion) <= Sys(11,m.fin) and ;
       		llamadas.usuario		= usuarios_cia.codigo		and ;
			llamadas.oficina		= oficina.codigo			and ;
			llamadas.dispositivo	= dispositivo.codigo		and ;
			llamadas.ingeniero		= ingeniero.codigo			and ;
			llamadas.grupo			= grupos_ing.codigo			and ;
			llamadas.servicio		= sub_unidades.codigo		;
order by numero ;
group by numero
if llamadas.dispositivo = dispositivo.codigo and ;
query line is not correct it doesn't bring the record, how can i do to bring the record even if the join is not correct?.

Thanks for the help.
Next
Reply
Map
View

Click here to load this message in the networking platform