You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select t1.*,t2.*,t3.*,t4.* from table1 t1, table2 t2, table3 t3, table4 t4
where http://t1.ID=t2.ID -> 1st condition
and http://t1.ID=t3.ID -> 2nd condition
and http://t1.ID=t4.ID -> 3rd condition
and
t4.mydate between '1.1.2009' and '1.6.2009' -> 4th condition
group by http://t1.name -> 5th
order by
date -> 6th
this is only example.
and now 1,2,3 and 4 condition running in the same time.
The text was updated successfully, but these errors were encountered:
Submitted by: Ivan (patuljak)
if we have query with few where condition
example
select t1.*,t2.*,t3.*,t4.* from table1 t1, table2 t2, table3 t3, table4 t4
where
http://t1.ID=t2.ID -> 1st condition
and
http://t1.ID=t3.ID -> 2nd condition
and
http://t1.ID=t4.ID -> 3rd condition
and
t4.mydate between '1.1.2009' and '1.6.2009' -> 4th condition
group by
http://t1.name -> 5th
order by
date -> 6th
this is only example.
and now 1,2,3 and 4 condition running in the same time.
The text was updated successfully, but these errors were encountered: