All pastes #128287 Raw Edit

Unnamed

public text v1 · immutable
#128287 ·published 2006-08-12 21:35 UTC
rendered paste body
select top 5 id_call, id_client, cost from calls where client_type='2' 

17082	12	1.0380
10033	12	.0040
10084	12	.0500
10370	12	.1200
11600	12	.0080


select top 5 c.id_call, c.id_client, c.cost, e.id_reseller from calls as c left join clientse164 as e on c.id_client=e.id_client and c.client_type='2'


13044	137	.0006	NULL
13045	137	.0022	NULL
13120	7861	1.7000	NULL
13121	1950	.2000	NULL
13122	137	.0202	NULL