Welcome Guest [Log In] [Register]
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:

Username:   Password:
Add Reply
Trivial Question 3; Database naman try lang
Topic Started: Jun 27 2010, 11:07 AM (211 Views)
jbdan0619
Member Avatar
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 :D
Posted Image


"You procrastinate, yes, and therein lies the secret of your eventual doom.."
Offline Profile Quote Post Goto Top
 
bashi
Member Avatar
Pentium 3
[ *  *  *  * ]
jbdan0619
Jun 27 2010, 11:07 AM
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 :D
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:
Posted Image
Offline Profile Quote Post Goto Top
 
jbdan0619
Member Avatar
Celeron
[ *  *  * ]
bashi
Jun 27 2010, 04:22 PM
jbdan0619
Jun 27 2010, 11:07 AM
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 :D
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:
ahahahha.. correct wew.. dapat hndi kaw sumagot nito pogi ta alm mo ito eh..
dapat mga lower years ahahah


:D galing galing

Alam mo na sagot sa question 2?
eheheh basahin mo nalng
Posted Image


"You procrastinate, yes, and therein lies the secret of your eventual doom.."
Offline Profile Quote Post Goto Top
 
bashi
Member Avatar
Pentium 3
[ *  *  *  * ]
jbdan0619
Jun 27 2010, 05:07 PM
bashi
Jun 27 2010, 04:22 PM
jbdan0619
Jun 27 2010, 11:07 AM
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 :D
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:
ahahahha.. correct wew.. dapat hndi kaw sumagot nito pogi ta alm mo ito eh..
dapat mga lower years ahahah


:D galing galing

Alam mo na sagot sa question 2?
eheheh basahin mo nalng
kita ko n... hahaha....

hindi kc ako sure un right term e... sori nmn... :(

prize ko?... ty... :rwar:
Posted Image
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Questions Section · Next Topic »
Add Reply


Latest posts is now loading...Please wait...
Free Domain Name Service