MySQL Forums

Hi

I have two tables:

Table A: Group
-----------------
GID
---
1
2
3
4


Table B: Orders
----------------
GID Cat
--------------
2 34
3 45
1 50
4 90


now i want to a stored procedure to remove the records from "Orders" which matches with the GID in the group table.

what to do? please help