E
efandango
I want to Find any record using the ‘Run_No’ as the User parameter, where it
will find any other ‘Run_No’ with a matching Keycode for Run_From_Postcode
or/and Run_To_Postcode.
The twist is that the Keycode from a given Run_No can have 2 different
Keycodes; as in the Run_No 1 example
Run_No KeyCode Run_From_Postcode Run_To_Postcode
1 N1 N4 N1
1 N4 N4 N1
1 N1 N4 N1
1 N4 N4 N1
80 N4 N2 N4
80 N4 N2 N4
80 N4 N2 N4
37 N4 N3 N4
37 N4 N3 N4
41 N1 N2 N4
41 N1 N2 N4
This is my SQL without any criteria:
SELECT FindCodes.KeyCode, FindCodes.Run_No, FindCodes.Run_From_Postcode,
FindCodes.Run_To_Postcode, FindCodes.Run_From, FindCodes.Run_To,
FindCodes.Run_Point_Venue_A, FindCodes.Run_Point_Address_A
FROM FindCodes
ORDER BY FindCodes.Run_No;
will find any other ‘Run_No’ with a matching Keycode for Run_From_Postcode
or/and Run_To_Postcode.
The twist is that the Keycode from a given Run_No can have 2 different
Keycodes; as in the Run_No 1 example
Run_No KeyCode Run_From_Postcode Run_To_Postcode
1 N1 N4 N1
1 N4 N4 N1
1 N1 N4 N1
1 N4 N4 N1
80 N4 N2 N4
80 N4 N2 N4
80 N4 N2 N4
37 N4 N3 N4
37 N4 N3 N4
41 N1 N2 N4
41 N1 N2 N4
This is my SQL without any criteria:
SELECT FindCodes.KeyCode, FindCodes.Run_No, FindCodes.Run_From_Postcode,
FindCodes.Run_To_Postcode, FindCodes.Run_From, FindCodes.Run_To,
FindCodes.Run_Point_Venue_A, FindCodes.Run_Point_Address_A
FROM FindCodes
ORDER BY FindCodes.Run_No;