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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
composite table columns
i have a composite attribute, person_name, under table 1. person_name has first_name, last_name, middle_initial...etc. how do i write a query to pull out just those names by first name? when i try to say: select first_name from table 1; it tells me that first_name is an invalid column name... -
query troubles
i know this might seem like a simple question, but's it's been a little while since i used sql. i am trying to combine three different tables example: table 1 (primary key) user history (primary key) project id table 2 (primary key) project id project name table 3 (primary key)...
