Find Jobs
Hire Freelancers

Change SQL-query to only collect posts that doesnt exist in other table

$10-30 USD

Selesai
Disiarkan sekitar 7 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran
I have a database attached through ODBC to an mssql database and do have a SQL-question that retrieves data. Now I want it to retrieve all post that are in [Reservdelar, bildlista egna - Blad1] but not in [login to view URL] Can you help me? SELECT [login to view URL] AS ID, "0" AS [Active(0/1)], [login to view URL] AS Name, [login to view URL], [login to view URL] AS [Price tax excluded or Price tax included], 53 AS [Tax rules ID], [login to view URL] AS [Wholesale price], "" AS [On Sale], "" AS [Discount amount], "" AS [Discount percent], "" AS [Discount from (yyyy-mm-dd)], "" AS [Discount to (yyyy-mm-dd)], [login to view URL] AS [Reference #], [login to view URL] AS [Supplier reference #], [login to view URL], [login to view URL] AS Manufacturer, First([login to view URL]) AS EAN13, 0 AS ECOTAX, [login to view URL] AS Weight, [login to view URL] AS [Product creation date], 1 AS [Available for order (0 = No, 1 = Yes)], 1 AS [Show price (0 = No, 1 = Yes)], 1 AS [ID / Name of shop], "new" AS Condition, [login to view URL], [login to view URL], [login to view URL], "Trollbacksvagen" AS Warehouse, [Reservdelar, bildlista egna - Blad1].ANTAL AS [house Quantity], UCase([Lagerplats]) AS [Warehouse Location] FROM (((dbo_ARTIKLAR_EAN RIGHT JOIN dbo_ARTIKLAR ON [login to view URL] = [login to view URL]) INNER JOIN dbo_ARTIKLAR_INKOP ON [login to view URL] = [login to view URL]) INNER JOIN dbo_LEVERANTORER ON [login to view URL] = [login to view URL]) INNER JOIN [Reservdelar, bildlista egna - Blad1] ON [login to view URL] = [Reservdelar, bildlista egna - Blad1].Levartnr GROUP BY [login to view URL], "0", [login to view URL], [login to view URL], [login to view URL], 53, [login to view URL], "", "", "", "", "", [login to view URL], [login to view URL], [login to view URL], [login to view URL], 0, [login to view URL], [login to view URL], 1, 1, 1, "new", [login to view URL], [login to view URL], [login to view URL], "Trollbacksvagen", [Reservdelar, bildlista egna - Blad1].ANTAL, UCase([Lagerplats]), [login to view URL] HAVING ((([login to view URL]) Not Like "V*") AND (([login to view URL])=1) AND (([login to view URL]) Like "036" Or ([login to view URL]) Like "HAKO" Or ([login to view URL]) Like "BRIGGS" Or ([login to view URL]) Like "180" Or ([login to view URL]) Like "5562878164" Or ([login to view URL]) Like "1004" Or ([login to view URL]) Like "1010" Or ([login to view URL]) Like "JOFRAB" Or ([login to view URL]) Like "1061" Or ([login to view URL]) Like "5567099253" Or ([login to view URL]) Like "STIGA" Or ([login to view URL]) Like "EINHELL" Or ([login to view URL]) Like "OREGON" Or ([login to view URL]) Like "SWED")) OR ((([login to view URL]) Like "036" Or ([login to view URL]) Like "HAKO" Or ([login to view URL]) Like "BRIGGS" Or ([login to view URL]) Like "180" Or ([login to view URL]) Like "5562878164" Or ([login to view URL]) Like "1004" Or ([login to view URL]) Like "1010" Or ([login to view URL]) Like "JOFRAB" Or ([login to view URL]) Like "1061" Or ([login to view URL]) Like "5567099253" Or ([login to view URL]) Like "STIGA" Or ([login to view URL]) Like "EINHELL" Or ([login to view URL]) Like "OREGON" Or ([login to view URL]) Like "SWED")) ORDER BY [login to view URL]; [login to view URL]
ID Projek: 13405410

Tentang projek

13 cadangan
Projek jarak jauh
Aktif 7 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
A proposal has not yet been provided
$30 USD dalam 0 hari
4.9 (29 ulasan)
4.9
4.9
13 pekerja bebas membida secara purata $31 USD untuk pekerjaan ini
Avatar Pengguna
Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. To understand your query and requirement better, is it possible to connect to your server and write the query there? Thanks Roni
$30 USD dalam 1 hari
5.0 (75 ulasan)
6.4
6.4
Avatar Pengguna
Hello, Can you send me database script with sample data so that I could verify my query first and then give you as you want thanks
$25 USD dalam 1 hari
5.0 (5 ulasan)
4.5
4.5
Avatar Pengguna
Please review my profile. I have 7.3 years experience in SQL. Please let me know more details and when we will start. Sky pe jikenjd
$30 USD dalam 1 hari
5.0 (22 ulasan)
4.0
4.0
Avatar Pengguna
Hi, I am a .NET developer with 10+ years of experience. I can complete your project in maximum 1 day. Please contact me if interested. Regards, Mladen
$31 USD dalam 1 hari
5.0 (3 ulasan)
2.9
2.9
Avatar Pengguna
I am having 10+ years of experience in SQL development. I have worked on large databases with very effectively and efficiently. I have worked on complex queries to get desired output. You can trust me to get desired output with best way.
$29 USD dalam 2 hari
5.0 (1 ulasan)
0.5
0.5
Avatar Pengguna
Knowledge in several programming languages with experience in systems maintenance in production. Knowledge to publish websites. Profound knowledge in classic ASP, VBA with Excel, Access and Word
$35 USD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
When I`m starting with some project I`m doing my best. I`m precise, hard working person. I would like to work with you.
$30 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I have 4 years experience in SQL and I believe if I can see your database, I can solve your problem within 7 days.
$25 USD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi, I'm a french software engineer, and I new to this website. I just create my compagny, and I develop software for compagnies. I worked for 10 years as a software engineer for compagnies, as well as MySQL and SQL Server databases. Now I used Delphi Berlin 10.1. I am available from now, and for the time you want. If you have any questions do not hesitate to contact me. Best Regards, ilatech team
$25 USD dalam 1 hari
5.0 (1 ulasan)
0.0
0.0

Tentang klien

Bendera SWEDEN
Tyresö, Sweden
5.0
4
Kaedah pembayaran disahkan
Ahli sejak Jul 29, 2016

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.