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!
-
merging results from two tables
I would like to ask for some help fixing this query: SELECT u.user_id, u.first_name, u.last_name, SUM( p.job_price ) AS 'used' FROM TestUsers AS u, TestPriceline AS p GROUP BY user_id; I want to merge columns from two tables to come up with the following result...
