Calling Sql Experts..

[YoungBlood]

Query paste cheyi.. Lolli enduku

[software]

Agreed with Youngblood mama

[rikki]

Answer nuve chepavu put union it between all those select statements done
[quote name='HyderabadPoradu' timestamp='1368555652' post='1303749556']



yea bhayya nen use chesina join tho cartiesian result vastundi...sachipotunna...


basic vishayam enti ante..

(table a join table Pulling 1 column from this join

(table a join table c) Pulling 1 column from this join

(table a join table d) Pulling 1 column from this join

So, ipudu naku emi kaval ante, paina vachina 3 columns anni oke result lo ravali...now, i can able to pull 1 column at 1 time...so nak ila vaddu... i need to pull all the 3 columns in 1 result set.


Ardam ayinda...or do i need to be more clear?
[/quote]

[HyderabadPoradu]

[quote name='software' timestamp='1368558286' post='1303750000']
Agreed with Youngblood mama
[/quote]
[quote name='YoungBlood' timestamp='1368556011' post='1303749584']
Query paste cheyi.. Lolli enduku
[/quote]

Ee DB lo evaryina maa office vallu unto naa bathuku kukka bathuku autadi...

PM cheyamantava?

Please help .....ela share cheyali mee andarki query ni...

[HyderabadPoradu]

[quote name='Donnie' timestamp='1368558506' post='1303750035']
Answer nuve chepavu put union it between all those select statements done
[/quote]


Union petti try chesa...

enduko mari only 1st column result matramee vastunnai...2 column and 3 rd column ravatledhu..

[HyderabadPoradu]

Query ikkada paste cheste prob autundi emo...evadyina maa office vallu unte...

Meeku PM cheyadaniki try chestunte error vastundi...what to do..

help me pls.

[HyderabadPoradu]

Help Pls.

LTT

[Mrlavangam]

select (neeku kavaalsina 3 columns raayi)
from table a
join b( 'a' ni 'b' tho join chey)
join c ('a' ni 'c' tho join chey)
join d('a' ni 'd' tho join chey)

[sarafpradeep]

nuvvu ichina info based kinda query.. try cheyu rakapothe, additional info ivvu.

DB-AdventureWorks

select pd.description, c.name, pm.instructions
from production.productdescription as pd
join production.productmodelproductdescriptionculture pc on pd.productdescriptionid = pc.productdescriptionid
join production.culture c on c.cultureid = pc.cultureid
join production.productmodel pm on pm.productmodelid = pc.productmodelid

table a = production.productmodelproductdescriptionculture
table b = production.productdescription
table c = production.culture
table d = production.productmodel

[software]

nee 3 results came from 3 statements right??
then do this..
result
Sel result1.*,result2.col1 (col1--> your 2 result col required),result3.col2 (col2--> your 3rd result col required)
From result1,result2,result3
where
result1.all matching columns=result2.all matchingcolumns and
resul2.all matching columns=result3.all matchingcolumns and
result1.all matching columns=result3.all matchingcolumns

Dude, this query will blow out..!

Mee data modeller gadiki oka vandanam.


Simple ga cheppalantey...nee requiremnt lo something missing...nee join condition lo sense ledhu..
I think check back with you data modeller.if i am right , there should be a[color=#ff0000] reference table[/color] to point and join the tables in a right manner

[software]

all set aa??

[HyderabadPoradu]

Ledhu bhayya's...need to tweak the sql from scratch...pedda lolli pani undhi..


Thank you all for the help...I will post here again ..if i have any questions...

[gennyfan]

select
(col1 from (table a join table Pulling 1 column from this join),
(col2 from (table a join table c) Pulling 1 column from this join),
(col3 from (table a join table d) Pulling 1 column from this join)
from dual;

[nrikittu]

gp