FAQ

Sanja Byelkin wrote:

select * //select 1
from table1
where table1.field IN (select * from table1_1 //select 1.1
union //union 0.1
select * from table1_2) //select 1.2
union //union 1
select * //select 2
from table2
where table2.field=
(select //select 2.1
(select f1 from table2_1_1 //select 2.1.1
where table2_1_1.f2=table2_1_1.f3)
from table2_1
where table2_1.f1=table2.f2)

union //union 2
select * from table3; //select 3

You can find structure of st_select_lex(SELECT_LEX) & st_select_lex_unit
(SELECT_LEX_UNIT) in sql/sql_lex.h
In the picture in sql_lex.h there is a unit1.2 and a corresponding
select1.2.1, but what select statement do they refer to?


--
Dennis

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 5 | next ›
Discussion Overview
groupinternals @
categoriesmysql
postedMay 21, '04 at 10:07a
activeAug 13, '04 at 10:25a
posts5
users3
websitemysql.com
irc#mysql

People

Translate

site design / logo © 2021 Grokbase