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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 4846
-
join 2 tables in SUM IF statement-mysql
Dear swampBoogie Thanks a lot for your cooperation. It has worked. Regards -
join 2 tables in SUM IF statement-mysql
Thanks for your reply and the first table with the name of newsales with sample data is as under prod_code description quant location year record_num ACC001 Hair 6 12-M 2003 3842 ACC401 Velvet 27 05-P 2003 178 ACC403 Necklace 20 10-L... -
join 2 tables in SUM IF statement-mysql
I am trying to join 2 tables with in a SUM IF statement. the code is as under: SELECT prod_code, description, description1, quant, SUM(IF(newsales.location = '05-P', newsales.quant,''))P, SUM(IF(newsales.location = '10-L', newsales.quant,'')) L, SUM(IF(newsales.location = '12-M'... -
Delete first comma in every line
Hi every body! I have a file which has a comma at the start and end of every line beside with in the lines. Can any one knows how to get rid of first and last commas of every line? Thanks in advance.
