tirion_angel
07-21-2006, 10:51 AM
Okay, see, it's tricky, and therefore, MS Access is giving me fuss. Here's the thing.
I'm working from 5 tables - issues, modules, types, users, yesno
The records I need are in the issue table, but due to the way the table stroes the information, I need to join to another table to get the right display.
The fields in issues that I need are - target_date, issue_name, issue_id, testscript_rqd, testscript_complete, tested, tested_by, IT_testscript_complete, IT_tested, IT_tested_by, type_id, module_id, assigned_to, requested_by, date_resolved, migrations_instructions
The tricky part is the joins I think. The fields tested, it_tested come as a number. I need to join those to the yesno table so that I can get the value instead of the id number.
The fields tested_by, IT_tested_by, assigned_to, requested_by all have to be given as the user_name form the useres table (they conect with user_id)
type_id joins with type_id from the types table, but I need the type_name.
module_id joins with module_id from the modules table, but I need the module name.
I know how to do all of these in seperate SQL statements, but can I make it all in one?
I hope this makes sense...
I'm working from 5 tables - issues, modules, types, users, yesno
The records I need are in the issue table, but due to the way the table stroes the information, I need to join to another table to get the right display.
The fields in issues that I need are - target_date, issue_name, issue_id, testscript_rqd, testscript_complete, tested, tested_by, IT_testscript_complete, IT_tested, IT_tested_by, type_id, module_id, assigned_to, requested_by, date_resolved, migrations_instructions
The tricky part is the joins I think. The fields tested, it_tested come as a number. I need to join those to the yesno table so that I can get the value instead of the id number.
The fields tested_by, IT_tested_by, assigned_to, requested_by all have to be given as the user_name form the useres table (they conect with user_id)
type_id joins with type_id from the types table, but I need the type_name.
module_id joins with module_id from the modules table, but I need the module name.
I know how to do all of these in seperate SQL statements, but can I make it all in one?
I hope this makes sense...