Small fix to void sql conflicts.
[fa-stable.git] / sales / includes / db / sales_points_db.inc
index 6f54fa2206d86c6e432259582bb096fbd67c65a2..d444ea7676a9d749af86396ce8fd7e8bd1f00735 100644 (file)
@@ -38,7 +38,7 @@ function get_sales_point($id)
                .TB_PREF."sales_pos as pos,"
                .TB_PREF."locations as loc,"
                .TB_PREF."bank_accounts as acc"
-               ." WHERE id=$id AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code";
+               ." WHERE pos.id=$id AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code";
        
        $result = db_query($sql, "could not get POS definition");