First, thanks for at least viewing this thread. I'm really bad at joins and only occasionally get one right. It's a very abstract concept that I have great difficulty in building the pieces between the word "select" and the word "where".
I have tables with these relevant fields:
Message -- the English name of the integer found in Txn_Type (an integer).
Device_Name -- the English name of the integer value found in Device_Number
If I run a simple query against the TXN_LOG I'll end up with the device_number and txn_code like this: 12345 0001
I'd like the query to be translated into human-readable-English by joining those other tables where the above result would be like this: Terminal_67 Balance_Inquiry
Problem is I just can't see how to tie all those pieces together. It's just too complex. I can kind of see how I have to go from TXN_LOG to CODES by joining the Txn_Type field on both of them. And it looks like there should then be another bridge from the CODES table over to the MESSAGES table using Message_Key. How do you construct the bridges? Also, it looks like I can join the TXN_LOG and DEVICES tables by joining Device_Number. There just seems to be so many joins that I'm plain stuck trying to figure out the syntax. How do I write the join clause? Any help would be appreciated. Thanks.