Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-11-09 : 03:40:32
|
DECLARE @phone table(phone int );insert into @phone(phone)values(111)insert into @phone(phone)values(222)insert into @phone(phone)values(333)DECLARE @servis table(ph int ,servis nvarchar(20));insert into @servis(ph,servis)values(111,'aciq')insert into @servis(ph,servis)values(111,'bagli')insert into @servis(ph,servis)values(111,'birbasa')insert into @servis(ph,servis)values(222,'birbasa')DECLARE @qiymet table(serv nvarchar(20),qiym int);insert into @qiymet(serv,qiym)values('birbasa',1)insert into @qiymet(serv,qiym)values('bagli',1)insert into @qiymet(serv,qiym)values('aciq',1)select distinct(phone) as p,2 as deb from @phone as phleft join(select nomre, sum(qiyme) as meb from(select sw.ph as nomre,sw.servis ,qy.qiym as qiymefrom @servis as sw inner join @qiymet as qy on sw.servis=qy.serv )g group by nomre)o on o.nomre=ph.pbut i getting error error:Invalid column name 'p'.http://sql-az.tr.gg/ |
|
bitsmed
Aged Yak Warrior
545 Posts |
Posted - 2013-11-09 : 04:27:02
|
quote: Originally posted by pascal_jimiselect nomre, sum(qiyme) as meb from(select sw.ph as nomre,sw.servis ,qy.qiym as qiymefrom @servis as sw inner join @qiymet as qy on sw.servis=qy.serv )g group by nomre)o on o.nomre=ph.p
select nomre ,sum(qiyme) as meb from (select sw.ph as nomre ,sum(qiyme) as meb from @servis as sw inner join @qiymet as qy on sw.servis=qy.serv group by nomre ) as o on o.nomre=p.ph |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-09 : 10:36:28
|
[code]select distinct phone as p,2 as deb from @phone as phleft join(select nomre, sum(qiyme) as meb from(select sw.ph as nomre,sw.servis ,qy.qiym as qiymefrom @servis as sw inner join @qiymet as qy on sw.servis=qy.serv )g group by nomre)o on o.nomre=ph.phone[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2013-11-11 : 03:02:09
|
You cannot directly use alias name anywhere in the query except ORDER BY ClauseMadhivananFailing to plan is Planning to fail |
|
|
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-11-12 : 01:14:08
|
Thank you to all my friendsis special Thank you to all my friendsis special VISAKH MURUKESANhttp://sql-az.tr.gg/ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-12 : 01:42:05
|
quote: Originally posted by pascal_jimi Thank you to all my friendsis special Thank you to all my friendsis special VISAKH MURUKESANhttp://sql-az.tr.gg/
you're welcome ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|