Relational Databases.. uhh?! (1 Viewer)

[chosen_one]

K no matter what teacher tries to teach me i screw up every relational database i make
and i dont know howto write the queries in SQL anyone got some tips?!

 

[chanfky]

What are you trying to find out using the SQL?
I might be able to help you if you tell my your problem

 

[chosen_one]

doing queries in SQL in a database

 

[chanfky]

Yeah I know
but can you tell me what you need to do with the SQL?
e.g. look up a list of people who live in a certain suburb? or a list of tv programs watched by people over the age of 18?

those are just examples of what you can find with SQL

 

[del]

Yeah QBE in Access....

just make sure you know basic SQL just remember
SELECT
FROM
WHERE
ORDER BY

and string criteria should be enclosed in " " but not numbers

 

[chosen_one]

uh i can do the QBE thats easy but i wanted SQL for the exam oh well if anyone can post a sample query before 8 tommorow ill be happy