I'm new to this forum. I'm learning C and embedded SQL. I have a question.
In one of the project am doing, i want to check whether any records with a particular local_id and global_id is there in the database with in the last 90 days. If it is present, then it should fetch various details of those records.
I can implement this in two phases. one query for checking if it is present in the last 90 days. Second one for fetching records based on the output of 1st phase.
But, i believe this could be done in a single SQL Query. I'm not that advanced especially when it comes to embedded SQL. Any help would be highly appreciated. Thanks