Extract data with MS Access and SQL

$10-30 USD

Σε Εξέλιξη

Αναρτήθηκε

πάνω από 7 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

I want to extract data from my MSSQL-database which is linked with ODBC to MS Access. I have done a task in MS-access that extracts the data I want but when there is no EAN linked to the product the product doesnt show up in the list. I would like to collect both products with ean and products without ean. Can you help me to change the sql-question? "SELECT [login to view URL] AS ID, "0" AS [Active(0/1)], [login to view URL] AS Name, [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] FROM dbo_ARTIKLAR_EAN INNER JOIN ((dbo_ARTIKLAR 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]) ON [login to view URL] = [login to view URL] GROUP BY [login to view URL], "0", [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], [login to view URL] HAVING ((([login to view URL]) Not Like "V*") AND (([login to view URL])=1) AND (([login to view URL])=1) AND (([login to view URL]) Like "036" 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") AND (([login to view URL])=1)) ORDER BY [login to view URL];"

Microsoft Access

SQL

Ταυτότητα εργασίας: 11842120

Σχετικά με την εργασία

8 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@sergioobici

I have already the solution. You have to do a little change to your query. I can give you the correct version after the confirmation of the bid.

$20 USD σε 0 ημέρα

5,0

(1 αξιολόγηση)

0,7

8 freelancers δίνουν μια μέση προσφορά $27 USD για αυτή τη δουλειά

@fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

$24 USD σε 1 ημέρα

4,9

(63 αξιολογήσεις)

6,9

@havit

Dear Client, Yes, there is issue with joins. It can be easily corrected. Thank you, Regards, Havit

$30 USD σε 1 ημέρα

5,0

(6 αξιολογήσεις)

5,3

@crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.

$30 USD σε 3 ημέρες

4,9

(15 αξιολογήσεις)

3,7

@VladimirLilenko

Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!

$30 USD σε 0 ημέρα

4,8

(11 αξιολογήσεις)

3,5

@yoecmeus

A proposal has not yet been provided

$30 USD σε 1 ημέρα

0,0

(0 αξιολογήσεις)

0,0

@ParaisoSoftware

hello, Dear Revered, we are the company who work for your benefit. we are the company where work comes first rather then anything else. Please provide me a chance to discuss about this project. we will provide you with the best possible work where what you say, is what we do. thanking you. kind regards.

$25 USD σε 1 ημέρα

0,0

(0 αξιολογήσεις)

0,0

@aztekprogramming

A can assist and have lots of Access, SQL and data migration techniques. There are several ways to solve your problem and perhaps enhance like auto generating your own EAN or just modify the query.

$25 USD σε 1 ημέρα

0,0

(0 αξιολογήσεις)

0,0

@techwizards3

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements.i have right skills to work on this assignment my award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. can u provide your email or sky-pe etc for further discussion about the project. I am ready to discuss with you with best Regards

$23 USD σε 6 ημέρες