| Welcome to Scisforums. We hope you enjoy your visit. You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. Join our community! If you're already a member please log in to your account to access all of our features: |
| Trivial Question 3; Database naman try lang | |
|---|---|
| Tweet Topic Started: Jun 27 2010, 11:07 AM (211 Views) | |
| jbdan0619 | Jun 27 2010, 11:07 AM Post #1 |
|
Celeron
![]() ![]() ![]() ![]() ![]()
|
eheheh if your a MYSQL type of user, this might twitch you mind a little bit eheh transfrom this MYSQL query to MS ACCESS query : Select * from student join school using(school_id) join location on school.location_id = location.id; wew... medyo simple sa Mysql , pero its not the same with Access.. Promise
|
![]() "You procrastinate, yes, and therein lies the secret of your eventual doom.." | |
![]() |
|
| bashi | Jun 27 2010, 04:22 PM Post #2 |
|
Pentium 3
![]() ![]() ![]() ![]() ![]() ![]()
|
SELECT student.student_id, school.school_id, location.location_id FROM (location INNER JOIN school ON location.[location_id] = school.[location_id]) INNER JOIN student ON school.[school_id] = student.[school_id]; gnyan b?... wahahahahaha..... wild guess... >:) :rwar: |
| |
![]() |
|
| jbdan0619 | Jun 27 2010, 05:07 PM Post #3 |
|
Celeron
![]() ![]() ![]() ![]() ![]()
|
ahahahha.. correct wew.. dapat hndi kaw sumagot nito pogi ta alm mo ito eh.. dapat mga lower years ahahah galing galingAlam mo na sagot sa question 2? eheheh basahin mo nalng |
![]() "You procrastinate, yes, and therein lies the secret of your eventual doom.." | |
![]() |
|
| bashi | Jun 27 2010, 06:15 PM Post #4 |
|
Pentium 3
![]() ![]() ![]() ![]() ![]() ![]()
|
kita ko n... hahaha.... hindi kc ako sure un right term e... sori nmn... ![]() prize ko?... ty... :rwar: |
| |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Questions Section · Next Topic » |





![]](http://z3.ifrm.com/static/1/pip_r.png)





4:35 PM Jul 11