Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
<cfquery name="get_categories" datasource="#application.dsn#" username="#application.dsnUsername#" password="#application.dsnPassword#"> SELECT * FROM bg_categories_2010 t1, bg_sub_categories_2010 t2, bg_advertiser_link_2010 t3, bg_advertiser_profile_2010 t4 WHERE (t1.id_category = t2.category_id AND t3.sub_cat_id = t2.id_sub_category AND t4.advertiser_id = t3.advertiser_id AND t4.active = '1') AND t1.reference_cat = '1' ORDER BY t1.category, t2.sub_category, t4.company_name </cfquery>
|How to add the results from a subquery to the main query||9||50|
|SQL Query Syntax: Why is the CTE Pulling in More Data Than Asked For?||5||40|
|Not Like IN Access Query not Working||10||31|
|Error converting data type nvarchar to bigint.||2||45|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!