Need help with joining these two queries....the newly created Item_Billing_Link record needs two items inserted Product_ID, and Bill_ID...here are the two queries to get these ID's that need to be inserted...



INSERT INTO Item_Billing_Link (Product_ID) SELECT Products.Product_ID FROM Customers INNER JOIN Products on Customers.Cust_ID = Products.Cust_ID WHERE Customers.Bill_Cycle_ID = '1' AND Products.Recurring = 'yes'

INSERT INTO Item_Billing_Link (Bill_ID) SELECT Bill_ID FROM Bills WHERE Bills.Bill_ID >= LAST_INSERT_ID ()

Thanks