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]