Inner Query in mysql
-
Is there any posibility of Inner Query in my SQL as Like MS Sql?
-
Is there any posibility of Inner Query in my SQL as Like MS Sql?
I'm actually not sure what Inner Query means, I'm guessing a subquery, if so then this should help http://dev.mysql.com/doc/refman/5.1/en/subqueries.html[^]
-
Is there any posibility of Inner Query in my SQL as Like MS Sql?
You need to expand on your question so that we can answer it correctly and hopefully save you time. also have a read of this in case the other answer is not what you are looking for. MySQL Inner joins[^]
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
-
Is there any posibility of Inner Query in my SQL as Like MS Sql?
Do you mean nested Selects? i.e.
Select something From tableThis Where ID In (Select somethingelse From tableThat Where condition );
if you do then; http://dev.mysql.com/doc/refman/5.0/en/subqueries.html[^]
Dave Find Me On: Web|Facebook|Twitter|LinkedIn
Folding Stats: Team CodeProject
-
Do you mean nested Selects? i.e.
Select something From tableThis Where ID In (Select somethingelse From tableThat Where condition );
if you do then; http://dev.mysql.com/doc/refman/5.0/en/subqueries.html[^]
Dave Find Me On: Web|Facebook|Twitter|LinkedIn
Folding Stats: Team CodeProject
Thanks for good comment dear... but this syntex not working proper now i m sending my sample query on message board. "SELECT * From tbladussentry where SID in (select Id from tbladusentry where SID in ( select ID from tbladuset where CID in(108,367)))"
-
Thanks for good comment dear... but this syntex not working proper now i m sending my sample query on message board. "SELECT * From tbladussentry where SID in (select Id from tbladusentry where SID in ( select ID from tbladuset where CID in(108,367)))"
I know you asked for subqueries however in this case I think joins are easier to read and more elegant:
select t1.*
From tbladussentry t1
join tbladusentry t2
on t1.SID = t2.Id
join tbladuset t3
on t2.SID = t3.ID
and t3.CID in(108,367)Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
-
I know you asked for subqueries however in this case I think joins are easier to read and more elegant:
select t1.*
From tbladussentry t1
join tbladusentry t2
on t1.SID = t2.Id
join tbladuset t3
on t2.SID = t3.ID
and t3.CID in(108,367)Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
Thanks dear....You are probably right but there is something more.......Look at my Example proper and told that is possible or not in MySql