SQL Queries practice thread

[king420]

[quote author=C Nation link=topic=201842.msg2463576#msg2463576 date=1307847536]
a, b ani asalu ivvaru.
may be select statement across different databases aithe use cheyyochu anukunta.
a represents database1, b represents database2.
[/quote] oka example query raayi  sCo_^Y sCo_^Y sCo_^Y

[stewiegriffin]

[quote author=C Nation link=topic=201842.msg2463576#msg2463576 date=1307847536]
a, b ani asalu ivvaru.
may be select statement across different databases aithe use cheyyochu anukunta.
a represents database1, b represents database2.
[/quote]
ee column use chesi join chesav????

[king420]

MDX queries ki  T SQL queries ki difference enti?  sCo_^Y sCo_^Y sCo_^Y

[stewiegriffin]

tables ki alternate names ivvacchu...
select * from table1 a 
join table2 b
a.id=b.id

ante table1&2 ki alternate names iccha...so that we dnt need to mention the tables names in after join
using of 'AS' is optional

[C Nation]

[quote author=HAPPYNESS link=topic=201842.msg2463577#msg2463577 date=1307847575]
oka example query raayi  sCo_^Y sCo_^Y sCo_^Y
[/quote]
example aaaa.  sCo_^Y sCo_^Y sCo_^Y sCo_^Y
ok database b1 has table user with columns userID, FullName.
Database b2 as table address with columns UserID, Address1

select b1.user.*, b2.address.Address1
from b1.user inner join b2.address on  b1.user.userID= b2.address.userId

concept aithe adhi. database.table  syntax lo mistakes undochu. aa syntax gurthu ledhu.

[C Nation]

[quote author=stewiegriffin link=topic=201842.msg2463591#msg2463591 date=1307847898]
tables ki alternate names ivvacchu...
select * from table1 a 
join table2 b
a.id=b.id

ante table1&2 ki alternate names iccha...so that we dnt need to mention the tables names in after join
using of 'AS' is optional
[/quote] @gr33d @gr33d @gr33d @gr33d

a.table1. productID = b.table2. productID

kaani ikkada a.table1 ani adigaadu kada.

[JUJUBI_JULABI]

[quote author=HAPPYNESS link=topic=201842.msg2463586#msg2463586 date=1307847794]
MDX queries ki  T SQL queries ki difference enti?  sCo_^Y sCo_^Y sCo_^Y
[/quote]
T sql = relational
MDX = multi dimention i.e cube

[king420]

[quote author=stewiegriffin link=topic=201842.msg2463591#msg2463591 date=1307847898]
tables ki alternate names ivvacchu...
select * from table1 a 
join table2 b
a.id=b.id

ante table1&2 ki alternate names iccha...so that we dnt need to mention the tables names in after join
using of 'AS' is optional
[/quote] thankyou thankyou thankyou thankyou H&*() H&*()

[king420]

[quote author=C Nation link=topic=201842.msg2463593#msg2463593 date=1307847921]
example aaaa.  sCo_^Y sCo_^Y sCo_^Y sCo_^Y
ok database b1 has table user with columns userID, FullName.
Database b2 as table address with columns UserID, Address1

select b1.user.*, b2.address.Address1
from b1.user inner join b2.address on  b1.user.userID= b2.address.userId

concept aithe adhi. database.table  syntax lo mistakes undochu. aa syntax gurthu ledhu.
[/quote]

deeni output
User, Address 2 columns vastaya??? S%Hi S%Hi

[C Nation]

[quote author=HAPPYNESS link=topic=201842.msg2463619#msg2463619 date=1307848284]
deeni output
User, Address 2 columns vastaya??? S%Hi S%Hi
[/quote]
user.* gives me 2 columns userid, fullname.
address kooda select statement lo rasa kada. so totally 3 columns

[chicago]

[quote author=C Nation link=topic=201842.msg2463598#msg2463598 date=1307847983]
@gr33d @gr33d @gr33d @gr33d

a.table1. productID = b.table2. productID

kaani ikkada a.table1 ani adigaadu kada.
[/quote]

different databases ni okesari use cheyocha.....a and b databases ayithay

[king420]

parametrized reports ante enti ??? mana Mass basha lo cheppu burraki baaga ekkuthundi  sCo_^Y sCo_^Y sCo_^Y

[C Nation]

[quote author=chicago link=topic=201842.msg2463632#msg2463632 date=1307848565]
different databases ni okesari use cheyocha.....a and b databases ayithay
[/quote]u can use multiple databases in single query.

[stewiegriffin]

i have a doubt....
i've two tables..one with composite primary key(id,sid) and another with out any keys...
now  i want to alter the second table nd change the sid in it, to foreign key of first...
kudurutunda

[king420]

[quote author=stewiegriffin link=topic=201842.msg2463657#msg2463657 date=1307849026]
i have a doubt....
i've two tables..one with composite primary key(id,sid) and another with out any keys...
now  i want to alter the second table nd change the sid in it, to foreign key of first...
kudurutunda
[/quote] sCo_^Y sCo_^Y sCo_^Y sCo_^Y kudurtundi leee marchei  @3$% @3$% @3$% ennno cheesam idokkati cheyyalema  @3$% @3$%