|
Smarty
WARNING: All discussion is moving to https://reddit.com/r/smarty, please go there! This forum will be closing soon. |
|
View previous topic :: View next topic |
Author |
Message |
globus Smarty n00b
Joined: 12 Sep 2007 Posts: 2
|
|
Back to top |
|
sergNN Smarty Rookie
Joined: 10 Oct 2006 Posts: 12 Location: Bad Homburg
|
Posted: Tue Sep 18, 2007 1:25 pm Post subject: |
|
|
???? ???? ???? ??? (??? ? ??? ?????????) :
select a.id, a.cat_id, name, a.published
from
table_add a, table_cat b
where
b.id=a.cat_id
??? ??? ??????? ??????? - ?????????????, ??? ??? ???? cat_id ???? ?????? ? ??????? table_cat.
???? ?????? ????, ?? ??? ????? ???? ?????? (?? ????? ?? ????? ??????), ?? ?????????
select
a.id, a.cat_id, nvl(name, "undefined"), a.published
from
table_add a, table_cat b
where
b.id=a.cat_id
???? ?????? ????? ?? ????, ?? ????????? join (??????? ?????? ???? ????, ??? ??? ?????), ???? ???????????? ??? ?????? ?? ?????? ???????. ?? ??????, ??? ?????????? join ? ?????? ? ? Mysql ??????. |
|
Back to top |
|
sergNN Smarty Rookie
Joined: 10 Oct 2006 Posts: 12 Location: Bad Homburg
|
Posted: Tue Sep 18, 2007 1:27 pm Post subject: |
|
|
???? ???? ???? ??? (??? ? ??? ?????????) :
Code: |
select a.id, a.cat_id, name, a.published
from
table_add a, table_cat b
where
b.id=a.cat_id |
??? ??? ??????? ??????? - ?????????????, ??? ??? ???? cat_id ???? ?????? ? ??????? table_cat.
???? ?????? ????, ?? ??? ????? ???? ?????? (?? ????? ?? ????? ??????), ?? ?????????
Code: |
select
a.id, a.cat_id, nvl(name, "undefined"), a.published
from
table_add a, table_cat b
where
b.id=a.cat_id |
???? ?????? ????? ?? ????, ?? ????????? join (??????? ?????? ???? ????, ??? ??? ?????), ???? ???????????? ??? ?????? ?? ?????? ???????. ?? ??????, ??? ?????????? join ? ?????? ? ? Mysql ??????. |
|
Back to top |
|
sergNN Smarty Rookie
Joined: 10 Oct 2006 Posts: 12 Location: Bad Homburg
|
Posted: Tue Sep 18, 2007 1:27 pm Post subject: |
|
|
Code: |
???? ???? ???? ??? (??? ? ??? ?????????) :
select a.id, a.cat_id, name, a.published
from
table_add a, table_cat b
where
b.id=a.cat_id
??? ??? ??????? ??????? - ?????????????, ??? ??? ???? cat_id ???? ?????? ? ??????? table_cat.
???? ?????? ????, ?? ??? ????? ???? ?????? (?? ????? ?? ????? ??????), ?? ?????????
select
a.id, a.cat_id, nvl(name, "undefined"), a.published
from
table_add a, table_cat b
where
b.id=a.cat_id
???? ?????? ????? ?? ????, ?? ????????? join (??????? ?????? ???? ????, ??? ??? ?????), ???? ???????????? ??? ?????? ?? ?????? ???????. ?? ??????, ??? ?????????? join ? ?????? ? ? Mysql ??????.
|
|
|
Back to top |
|
serious_sam Smarty n00b
Joined: 04 Jun 2008 Posts: 3
|
Posted: Wed Jun 04, 2008 4:14 pm Post subject: |
|
|
spasibo |
|
Back to top |
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|