Completed

Simple SQL Query

If I run the following:

select SeasonID from Seasons where ClubID = 35 and Webpage = 'LeagueTables'

it outputs

51

54

56

58

62

88

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!

Skills: SQL

See more: sql query get group field that has all active items, simple delete query sql php, query sql retrieve tree table, php, data processing, c# programming, sql, asp.net, database development, arcgis vba query sql server, access database sql simple project, tree query sql, dnn query sql, sql script row sequence number, php html query sql, query creator simple, run query cron simple, uusing data adaptor aspnet query sql server database, parent child query sql server, godaddy simple control panel ftp delete

About the Employer:
( 69 reviews ) Portsmouth, United Kingdom

Project ID: #14692237

Awarded to:

angnut

Hi,i am available and i need a good feedback. I will do in 30 minutes but i will be at home within 2 hours

£10 GBP in 1 day
(5 Reviews)
2.6

35 freelancers are bidding on average £16 for this job

£18 GBP in 1 day
(14 Reviews)
5.7
bhaveshghodasara

one sql query to delete record in child table if record not present in master/parent table. Relevant Skills and Experience 12 years experience in writing SQLs :) Proposed Milestones £10 GBP - one sql query to delete More

£10 GBP in 1 day
(7 Reviews)
4.6
bhupen2606

The query sounds very simple. i am bidding at minimum amount allowed by this website. However, let's have a quick chat and i might do it for even less (or let you decide on amount :) Relevant Skills and Experience SQL More

£10 GBP in 1 day
(21 Reviews)
4.2
£10 GBP in 1 day
(6 Reviews)
4.0
£18 GBP in 1 day
(8 Reviews)
3.6
arityinfoway

I have more than 7+ years of experience in .NET, c#.net, vb.net, asp.net, MVC, VBA, Odoo, sql, mysql, Oracle, Azure, Entity Framework, Linq, Umbraco, Telerik, Devexpress, JQuery, Angularjs, CSS, HTML. Relevant Skills More

£17 GBP in 1 day
(4 Reviews)
3.5
expertatwork

It's a very simple one line query. Thank you.

£10 GBP in 0 days
(7 Reviews)
3.4
£13 GBP in 1 day
(5 Reviews)
3.3
TSCreators

hi , i am expert on it you can pay me after get success result . regards tscreators Relevant Skills and Experience hi , i am expert on it you can pay me after get success result . regards tscreators Proposed Milest More

£18 GBP in 1 day
(2 Reviews)
3.0
vibhav107

Dear Sir, I'm having an experience to make complex queries. I can update your query within minimum time. Thanks I look forward to hearing from you soon. Thanks Relevant Skills and Experience SQL Proposed Milestone More

£15 GBP in 1 day
(2 Reviews)
2.7
MimiFL

Creating SQL query to remove rows whose SessionID doesn't exist in Leagues table, following the specific rules. Relevant Skills and Experience I've completed hundreds of SQL projects and i work with SQL databases ( More

£10 GBP in 0 days
(6 Reviews)
2.6
mdramindz

I Am Mousumi 8 years experienced in website and web application design and development and 3 years experienced in mobile apps. I work on Asp.net, C#, MVC, Angular JS, Azure, SQL server, Android Relevant Skills and More

£19 GBP in 1 day
(1 Review)
2.3
arnoldbenda

Hi dear man. I readed your project very carefully. I developed website for 5+ years. I am good at PHP, MYSQL, HTML, CSS, JAVASCRIPT. I am sure I can do your work. Please contact me. Thank you.

£18 GBP in 1 day
(4 Reviews)
2.2
gangradeankit

will do it just now Relevant Skills and Experience sql query Proposed Milestones £15 GBP - ml1 initiate chat

£15 GBP in 1 day
(1 Review)
0.8
MohsanEijaz

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

£28 GBP in 1 day
(0 Reviews)
0.0
Elkaryx21

A proposal has not yet been provided

£10 GBP in 1 day
(0 Reviews)
0.0
L1Ntu

Hello Will do that quick Relevant Skills and Experience sql Proposed Milestones £13 GBP - project

£13 GBP in 1 day
(0 Reviews)
0.0
alexhsia

I am current a data developer, and i'm good at sql. Relevant Skills and Experience sql Stay tuned, I'm is still working on this proposal.

£18 GBP in 1 day
(0 Reviews)
0.0
£18 GBP in 1 day
(0 Reviews)
0.0
madhugudibandla

A proposal has not yet been provided

£13 GBP in 1 day
(0 Reviews)
0.0