Forum FAQForum FAQSearchSearch MemberlistMemberlist Forum ignore listForum ignore list RegisterRegister ProfileProfile Log in to check your private messagesLog in to check your private messages Log inLog in
MySQL SELECT pomoć

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    mi3dot.org Forum Index -> Server-side
View previous topic :: View next topic  
Author Message
pozitron



Joined: 19 Oct 2008
Posts: 6
Location: Slavonsi Brod

PostPosted: 22.10.2008 10:15    Post subject: MySQL SELECT pomoć Add user to your forum ignore list Reply with quote

Imamo 2 Tablice

KNJIGA i PODKNJIGA

KNJIGA = IDzapis, datum
PODKNJIGA = IDzapis, IDpodzapis, datum

Primjer:

600 je zapis u tablici KNJIGA
i on ima n broj pod zapisa 600/1 600/2 600/3 u PODKNJIGA tablici

KNJIGA

IDzapis____datum
600_______2008-10-01
601_______2008-10-09
602_______2008-10-18

PODKNJIGA

IDzapis__IDpodzapis__datum
600_____1__________2008-10-02
600_____2__________2008-10-20
602_____1__________2008-10-19

MOJ PROBLEM:

Možete li mi pomoći napisati SELECT upit koji bi ovo složio po Datumu
ORDER BY datum DESC

Rezultat bi trebao biti:

REZULTAT

IDzapis__IDpodzapis__datum
600_____2__________2008-10-20
602_____1__________2008-10-19
602________________2008-10-18
601________________2008-10-09
600_____1__________2008-10-02
600________________2008-10-01
Back to top
View user's profile Send private message
bj__



Joined: 09 Nov 2004
Posts: 65
Location: Karlovac

PostPosted: 22.10.2008 16:36    Post subject: Add user to your forum ignore list Reply with quote

ovo bi trebalo rijesiti problem:
Code:
SELECT knjiga.IDzapis AS IDzapis, null AS IDpodzapis, knjiga.datum AS datum FROM knjiga
UNION
SELECT podknjiga.IDzapis AS IDzapis, podknjiga.IDpodzapis AS IDpodzapis, podknjiga.datum AS datum FROM podknjiga
ORDER BY datum DESC


p.s. a da probas proci neki tutorial o izradi, normalizaciji i pisanju upita na baze? nista zlonamjerno, ali sigurno bi ti bilo korisno za ovakve stvari...
Back to top
View user's profile Send private message Twitter profile
pozitron



Joined: 19 Oct 2008
Posts: 6
Location: Slavonsi Brod

PostPosted: 22.10.2008 19:19    Post subject: Add user to your forum ignore list Reply with quote

Hvala bj__,

stvarno si rasturio ovaj Query.

Ispitao sam ga, radi baš onako kako i treba.

Što se tiče knjiga o MySQL imam ih puno, svaki dan prije spavanja još malo ponovim gradivo, ali ovakav upit kakav si mi ti napisao vjeruj mi nije lako napraviti bez obzira na primjere iz knjiga, to je ono između redova. Eto naš je posao takav da uvijek moraš znati više i više... Hvala Puno, dužnik sam Smile

Pozdrav
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    mi3dot.org Forum Index -> Server-side All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
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