MySQL Forums
Forum List  »  Stored Procedures

Re: How to join two tables through Select and Call Procedure.
Posted by: Roger Novelo
Date: April 11, 2019 12:27PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to join two tables through Select and Call Procedure.
601
April 11, 2019 12:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.