Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: vinceinhiding
- Order by date
-
SQL Select HELP!!!
This is the error. ERROR 1064: You have an error in your SQL syntax near 'SELECT salary FROM people)' at line 1 I am running this on mySQL. I have just learned that mySQL does not like nested SELECT statements. But i still havent figured out a way around it.- vinceinhiding
- Post #3
- Forum: ANSI_SQL
-
SQL Select HELP!!!
I have a table called people. Each person has a name, and income. I want to produce a set of records of people who have an income higher than that of a specific person (BOB). I want to refer to BOB's income as a select statement so that if it changes later on, the statement still holds it...- vinceinhiding
- Thread
- Replies: 3
- Forum: ANSI_SQL
