SQL structure rejected by Crystal

[tmccoy1]

My SQL query runs fine in SQL management studio, but when pasting it into an SQL command in Crystal it is rejected with " HIST ...label is not among the applicable tables". Any pointers appreciated. here is the SQL

Select chrg.field1, hist.field2, etc.
FROM billing_tx_charge_detail AS chrg
INNER
JOIN billing_tx_history AS hist
ON chrg.FACILITY = hist.FACILITY

 

[tmccoy1]

Nevermind. Found the issue. It was further down in my code in a union of the same tables and fields where I missed changing the alias from a copy/paste. DOAH!