HyderabadPoradu Posted May 14, 2013 Report Posted May 14, 2013 Bhayya's- total i have 3 tables... i need to join those 3 tables to get the result. Now, those 3 tables doesn't have any common keys. How to make a join of these tables to get the result? Please help..
Terminator II Posted May 14, 2013 Report Posted May 14, 2013 requirment not clear.. scenario inka detailed ga cheppu.. may be an example
Silver_mani Posted May 14, 2013 Report Posted May 14, 2013 [quote name='kevkekaa' timestamp='1368549034' post='1303748910'] requirment not clear.. scenario inka detailed ga cheppu.. may be an example [/quote] ah req correct ga chepte ???
cherlapalli_jailer Posted May 14, 2013 Report Posted May 14, 2013 3 tables ki Ee link lekapothe select * from ani 3tables mention cheyyi u will data from all the 3 tables without any link(need not be forergin key realation) at least data type relation anna vundali
innovative Posted May 14, 2013 Report Posted May 14, 2013 [quote name='HyderabadPoradu' timestamp='1368548917' post='1303748895'] Bhayya's- total i have 3 tables... i need to join those 3 tables to get the result. Now, those 3 tables doesn't have any common keys. How to make a join of these tables to get the result? Please help.. [/quote] common columns lepothe .. em result expect chesthunnav ..detail ga cheppu .. [quote name='kevkekaa' timestamp='1368549034' post='1303748910'] requirment not clear.. scenario inka detailed ga cheppu.. may be an example [/quote] +1
iTeachSAP Posted May 14, 2013 Report Posted May 14, 2013 [quote name='HyderabadPoradu' timestamp='1368548917' post='1303748895'] Bhayya's- total i have 3 tables... i need to join those 3 tables to get the result. Now, those 3 tables doesn't have any common keys. How to make a join of these tables to get the result? Please help.. [/quote] if you are joining tables which do not have a proper join will lead to a cartesian product mayya.. which are like incorrect results.. for example table a lo 10 rows unte.. table B lo 5 rows unte. .totally you wil get 50 rows
CheGuevara Posted May 14, 2013 Report Posted May 14, 2013 [quote name='HyderabadPoradu' timestamp='1368548917' post='1303748895'] Bhayya's- total i have 3 tables... i need to join those 3 tables to get the result. Now, those 3 tables doesn't have any common keys. How to make a join of these tables to get the result? Please help.. [/quote] common keys lekunte aa 3 tables join chesi em use mama....enduku join cheyyali anukuntunnav.... anyway look a row data in all the 3 tables...edo oka column common ga untadi..aa column meeda join chey
HyderabadPoradu Posted May 14, 2013 Author Report Posted May 14, 2013 NAA DEGGARA UNNA SQL THO MALLI VASTA...WAIT FOR 5 MINS BHAI LOG...
150bryant Posted May 14, 2013 Report Posted May 14, 2013 tables ki relation undi untadhi....sariga chudu
Terminator II Posted May 14, 2013 Report Posted May 14, 2013 [quote name='Silver_mani' timestamp='1368549096' post='1303748915'] ah req correct ga chepte ??? [/quote] [img]https://lh3.googleusercontent.com/-rb27hs4r0wE/Tp9yetnJWAI/AAAAAAAAErU/bCLjKg1pgeg/s150/Brahmi-4.gif[/img]
puli_keka Posted May 14, 2013 Report Posted May 14, 2013 common keys lekunda join aa.. paina cheppinattu cartesian joine dikku may be ila cheyochemo select distinct p.Name,P.ID,d.DepartmentName from Person p,Department d
littlemoon Posted May 14, 2013 Report Posted May 14, 2013 also cross join use cheyachu or union with 2 select statements.. [size=4] [/size]
software Posted May 14, 2013 Report Posted May 14, 2013 bhayya...neeku vertical join kavala, Horizontal join kavala.. Set Operation like Union try chey for all records into 1 one table... Vertical join chestha..cartesian result vasthadhi..nee dhula theruddhi..! Detail ga em kavalo..cheppu vayya..
HyderabadPoradu Posted May 14, 2013 Author Report Posted May 14, 2013 [quote name='software' timestamp='1368553998' post='1303749427'] bhayya...neeku vertical join kavala, Horizontal join kavala.. Set Operation like Union try chey for all records into 1 one table... Vertical join chestha..cartesian result vasthadhi..nee dhula theruddhi..! Detail ga em kavalo..cheppu vayya.. [/quote] 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?
Recommended Posts