Can someone tell me which table stores a customer’s constituencies? I know the table tr_constituency stores the names of the possible constituencies, but it does not connect to the customer_no. Which table will show me that customer_no 19996 has constituency ID of 18?
Thanks in advance!
Penny Tabor
IT Manager
Midland Center for the Arts
Midland, MI 48640
It's TX_CONST_CUST.
select * from tx_const_cust
where customer_no = 19996 and constituency = 18