Lukket

MYSQL queries

I need a simple MYSQL query. Basically im trying to cleanup some data. So need to check 2 tables to compare data. e.g

Table 1: products

products_id

1

2

5

7

Table 2: products_to_manufacturers

products_id manufacturers_id

1 1

2 1

3 1

4 1

5 2

6 2

7 2

8 2

9 2

basically ull see

table 1 has product id 1 2 5 7

table 2 has product id 1 2 3 4 5 6 7 8 9

i need a query to SELECT (i.e return) all products in table 2 which are NOT in table 1

the result in this case is obvious and will be 3 4 6 8 9

So the result returned should be

products_id manufacturers_id

3 1

4 1

6 2

8 2

9 2

Evner: MySQL

Se mere: building xml files mysql queries, optimize mysql queries, mysql php display tables data, oscommerce mysql queries pproducts_model, mysql error code 1054 using case, complex php mysql queries, optimize mysql queries script, mysql script dump tables, extract data mysql database display tables html perl, php mysql queries css instead tabs, send mysql queries perl, php mysql sorting html tables, mysql dropdown show tables, oscommerce mysql queries, cacti mysql queries, mysql queries locked state, sanitizing mysql queries php, mysql dumb fews tables, optimize mysql queries phpbb3

Om arbejdsgiveren:
( 7 bedømmelser ) Clydebank, United Kingdom

Projekt ID: #22716148

59 freelancere byder i gennemsnit $21 på dette job

mahamadali

I am experienced PHP developer and web designer with the depth knowledge related to MySQL,Codeigniter,Laravel,WordPress,MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS with the integration of web technologies. I have worked Flere

$30 USD på 1 dag
(296 bedømmelser)
7.3
vano101

Hello I have extensive experience with MySQL This query can be written in less than couple of hours of pure working time.

$15 USD på 1 dag
(88 bedømmelser)
5.9
bindmission

Hello Hope you are doing well. I have 7 years of experience in MySQL DB management. I can handle this project. Regards VishnuLal*

$30 USD på 1 dag
(91 bedømmelser)
5.7
Ferroigni

Hi, My name is Heorhii (George), I've read the description, everything makes sense I could start working on queries right now. Thanks, George

$30 USD på 1 dag
(10 bedømmelser)
5.6
gursukh

yes sure i can help you right now

$30 USD in 0 dage
(48 bedømmelser)
5.4
MagicIT

Hi there Lets start now I can do this now as per your requirements with a great perfection lets discuss more in message

$10 USD på 1 dag
(23 bedømmelser)
5.3
irfankhokhar1986

Hi, Greeting of day. I m Expert Professional Full stack developer Having 8+ Years Experience ***You will just see my reviews..!!!

$10 USD på 1 dag
(40 bedømmelser)
4.8
jamesmartin81

Hi, I am ready to start right away. I have reviewed your job description as well and very confident to handle this project perfectly. I will do multiple revision in your project with 100% satisfaction work guaranteed Flere

$20 USD på 1 dag
(44 bedømmelser)
4.8
topexpert713

Hi, Nice to meet you! I have read your requirements carefully and I am very interesting for your project. I am confident of this project as I'm a professional MYSQL expert with over 5 years of experience. It seems to b Flere

$20 USD på 1 dag
(2 bedømmelser)
3.6
sahilnarain

Hi, I've worked extensively on SQL queries, I can do this using appropriate joins. Please drop me a message if you'd like me to pick this up for you! Thanks

$10 USD på 1 dag
(5 bedømmelser)
3.2
monkeyMatrix

Hello? Expert Here. I can do it in few hours please send me msg. thank you.

$30 USD på 1 dag
(4 bedømmelser)
3.1
Dmitry610

Hello Dear, Greetings for the day! ⭐⭐⭐⭐⭐ I CAN START IMMEDIATELY ⭐⭐⭐⭐⭐ My name is Dmitry Kraitor and I am individual full-stack&full-time web developer. I have gone through the project description and I am very int Flere

$50 USD på 1 dag
(6 bedømmelser)
3.2
Snail0917

Please give me a chance to work with you. Mysql is a simple project for me. Hello sir! Nice to meet you. I am very interested in your project. I am a mysql expert. I have rich experience in this field. I am read Flere

$20 USD på 1 dag
(3 bedømmelser)
3.4
ksab

I can give the MYSQL code so that items in the first table are removed from the table in Table2. This can be done directly using SQL or it can be coded int PHP MYSQL project. Please let me know which one you require. Flere

$10 USD på 1 dag
(11 bedømmelser)
3.3
Fastforfreelance

Hi, I will make query as per your requirement. I am ready to start now. I can complete your task with complete satisfaction. I have 9 years experience in development and designing. I have made many projects like CMS, J Flere

$15 USD på 1 dag
(14 bedømmelser)
3.2
seniordev0425

Hi. I am a Database Developer. I have 5 years of experience working with SQL/MYSQL and Oracle. I am currently working on SQL server. I can show you my previous work related to DB. Please see my profile and reviews Flere

$20 USD på 1 dag
(3 bedømmelser)
2.9
AndreyBarykin

Hello. I have big experience as Senior Database Developer/DBA. I Know well SQL, make queries of any complexity.

$10 USD på 1 dag
(2 bedømmelser)
3.0
goodwork20k

I am good in mysql along with scripting and automation, please let me know if you are good to award this project to me

$30 USD på 1 dag
(2 bedømmelser)
2.9
ImmortalStas

I can build any sql queries in a short time. Please just hire me and see what I can do for you. Thanks.

$30 USD på 1 dag
(2 bedømmelser)
2.6
khaldalfalah

Hi, I am ready to create this query. I have experience in MS SQL server,asp.net, crystal reports and VB.net more than 12 years. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - Uni Flere

$30 USD på 1 dag
(1 bedømmelse)
2.5