Re: How to join two tables through Select and Call Procedure.

[Roger Novelo]

Hello guys, I'm still stuck with this whole thing. This is basically the logic behind what I want.



SELECT ID, (CALL isavailable(@ID,'2019-04-18','2019-04-24')) FROM inventory ORDER BY ID;

I would like each ID from inventory to be checked by the procedure to determine if the inventory ID is available.

Getting an output like..

ID | Available

17 | No
18 | Yes
23 | Yes
24 | Yes
40 | No
and so on...

Really need help this to finish my project guys, this is the only thing keeping me back from finishing.