SELECT Completion_checklist.*, Phase.Phase_ID AS Phase_ID_Phase
FROM Phase INNER JOIN Completion_checklist ON (Phase.Phase_ID = Completion_checklist.Phase_ID);
Best Regards
Aman
SELECT Completion_checklist.*, Phase.Phase_ID AS Phase_ID_Phase
FROM Phase INNER JOIN Completion_checklist ON (Phase.Phase_ID = Completion_checklist.Phase_ID);
Best Regards
Aman
they are pulling data from table/qry [Completion_checklist] joined to table/qry PHASE,
on field: PhaseID.
In layman's terms
SELECT all fields (*) from the table named Completion_checklist AND Phase_ID FROM Phase table (but let's call that Phase_ID_Phase) FROM these aforementioned tables BUT what is in Phase.Phase_ID record has to match (be equal to) what's in each record of Completion_checklist.Phase_ID.
I'm not smart but I do know how to use Google
https://support.microsoft.com/en-us/...4-e8dc3e460671
Last edited by Micron; 02-12-2021 at 02:50 PM. Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Appears to be a lost art these days.Originally Posted by Micron;470892
I'm not smart but I do know how to use Google
[URLhttps://support.microsoft.com/en-us/office/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671[/URL]
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
@Welshgasman
Now that's FUNNY!!!
Thanks.. I needed that....