Sql Query Question

[halwaraaj]

sql query help kavali bhayyas

eee kindi query naku all serial numbers associated with a particular project istundi


SELECT DISTINCT T0.SerialNum FROM
(
select DISTINCT SerialNum from dbo.dln1
where U_Project = '13746.012'
UNION ALL
select DISTINCT SerialNum from dbo.inv1
where U_Project = '13746.012'
UNION ALL
select DISTINCT SerialNum from dbo.rdr1
where U_Project = '13746.012'
) AS T0

naku serial numbers associated with each of the projects kavali.....all projects query emo


SELECT U_ProjCode FROM [dbo].[@PRJCTMNGR]
ORDER BY U_ProjCode

output column format ela kavali ante

col 1 col2
project 1 serialnum 1
project 1 serialnum 2
project 2 serialnum 3
..........


ela cheyalo ardham avatledu bhayyas.....plzz help.....

[iTeachSAP]

[img]http://1.bp.blogspot.com/-khRXpwKtAaI/UBOBkA8eXFI/AAAAAAAAFRI/HFIPnfT3U54/s1600/Brahmanandam-Saidulu-Muddula-Mogudu.gif[/img]

[ChampakDas]

Edit: nenu endho ardam cheskunna...question ardam kale

[halwaraaj]

[quote name='iTeachSAP' timestamp='1371743223' post='1303873791']
[img]http://1.bp.blogspot.com/-khRXpwKtAaI/UBOBkA8eXFI/AAAAAAAAFRI/HFIPnfT3U54/s1600/Brahmanandam-Saidulu-Muddula-Mogudu.gif[/img]
[/quote]

SAP bhayyo......neeku telise untadi.....jokulu/shocklu kakunda kasta cheppu bhayya....

[iTeachSAP]

Post edited to avoid confusion to user.. question confuse ayina..

[iTeachSAP]

[quote name='GatisKandis' timestamp='1371743253' post='1303873793']
select DISTINCT SerialNum from dbo.dln1
where U_Project IN (SELECT U_ProjCode FROM [dbo].[@PRJCTMNGR]
ORDER BY U_ProjCode)
[/quote]


user ki project wise ,serial numbers kavalante mama...


[color=#0000ff]select DISTINCT U_Project,SerialNum from dbo.dln1
where U_Project IN (SELECT U_ProjCode FROM [dbo].[@PRJCTMNGR]
ORDER BY U_ProjCode)[/color]

[ChampakDas]

edhi enti brother edharam query rasam...malli edharam edit chesham...edhariki ardam kale
[quote name='iTeachSAP' timestamp='1371743384' post='1303873803']
Post edited to avoid confusion to user.. question confuse ayina..
[/quote]

[ChampakDas]

ohh yeah project code select lo pedithey saripotundi...but I was not sure I understood it correctly
[quote name='iTeachSAP' timestamp='1371743490' post='1303873807']


user ki project wise ,serial numbers kavalante mama...


[color=#0000ff]select DISTINCT U_Project,SerialNum from dbo.dln1
where U_Project IN (SELECT U_ProjCode FROM [dbo].[@PRJCTMNGR]
ORDER BY U_ProjCode)[/color]
[/quote]

[halwaraaj]

[quote name='iTeachSAP' timestamp='1371743490' post='1303873807']


user ki project wise ,serial numbers kavalante mama...


[color=#0000ff]select DISTINCT U_Project,SerialNum from dbo.dln1
where U_Project IN (SELECT U_ProjCode FROM [dbo].[@PRJCTMNGR]
ORDER BY U_ProjCode)[/color]
[/quote]


thnx bhayyas