Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: SQL Query  (Read 2711 times)

0 Members and 1 Guest are viewing this topic.

goerge

  • Guest
SQL Query
« on: July 12, 2006, 07:13:49 AM »
I would like to write query that does the following
assuming: i hav a database with a table called Projects

a query that list details of any project i.e. when the user enters any ProjectID

SQL is crazy pls help

Rob Pomeroy



    Prodigy

  • Systems Architect
  • Thanked: 124
    • Me
  • Experience: Expert
  • OS: Other
Re: SQL Query
« Reply #1 on: July 12, 2006, 07:35:49 AM »
What program are you using to query the database?

The basic SQL query would be:
SELECT * FROM Projects WHERE ProjectID = x;
Replace x with the ID entered by the user.  How you do that depends on the answer to my first question.
Only able to visit the forums sporadically, sorry.

Geek & Dummy - honest news, reviews and howtos