If I run the following:
select SeasonID from Seasons where ClubID = 35 and Webpage = 'LeagueTables'
I now want to loop and find out if those 6 SeasonID's actually exist in my Leagues table. If any of them DO NOT exist in (select distinct SeasonID from Leagues), I want to delete the row from the Seasons table.
That's it. Sorry not much money but it's such a simple query I'm sure and I will leave great feedback. Cheers!
35 freelancers are bidding on average £16 for this job
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document Relevant Skills and Experience SQL Proposed Milestones £28 GBP - m