On a previous page I have list boxes to check choices. If one choice is made I can use the order by as shown in the following sql statement:
strSQL is SELECT * from (select tbl_fip_codes.fip_code, tbl_fip_codes.fip_name,tbl_bls_state_tran.sic,tbl_bls_state_tran.own,tbl_bls_state_tran.bls1976 as emp_bls2dg1976 FROM tbl_fip_codes INNER JOIN tbl_bls_state_tran ON tbl_fip_codes.fip_code = tbl_bls_state_tran.fip_code WHERE ((tbl_fip_codes.fip_code in ('05000'))and tbl_bls_state_tran.var_code='1' and sic != ' ')) as emp_bls2dg ORDER BY sic;
However, if I make two choices then the inner join comes after the ORDER BY and I get an error. I tried putting the ORDER BY after the where, but I still get an error. Any Suggestions?
strSQL is SELECT * from (select tbl_fip_codes.fip_code, tbl_fip_codes.fip_name,tbl_bls_state_tran.sic,tbl_bls_state_tran.own,tbl_bls_state_tran.bls1976 as emp_bls2dg1976 FROM tbl_fip_codes INNER JOIN tbl_bls_state_tran ON tbl_fip_codes.fip_code = tbl_bls_state_tran.fip_code WHERE ((tbl_fip_codes.fip_code in ('05000'))and tbl_bls_state_tran.var_code='1' and sic != ' ')) as emp_bls2dg ORDER BY sic inner join (select tbl_fip_codes.fip_code, tbl_bea_employ.bea_emp1971 as emp1971 FROM tbl_fip_codes INNER JOIN tbl_bea_employ ON tbl_fip_codes.fip_code = tbl_bea_employ.fip_code WHERE ((tbl_fip_codes.fip_code in ('05000'))and tbl_bea_employ.bea_code='25010')) as emp on emp_bls2dg.fip_code=emp.fip_code;
