Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
SQL Script
Name: Deon Date: April 30, 2008 at 06:29:26 Pacific OS: XP CPU/Ram: 2GHz /2GB Product: Custom Build
Comment:
Hi all. If got a Database that with tables. SKU and Orderdetail. Fields of Table SKU >> SKU, Placement, SUSR1 SUSR2. Fields of Table Orderdetail >> SKU, Placement, Desc, Value
In Table SKU and Orderdetail the SKU fields are the link between the two. Table SKU has one line and in Orderdetail are the detail lines (Example 6) of that enry in the SKU table. That items link back to the SKU table and kan have SUSR2 values of either 800 or 300. I want my script to link the tables and give me the result of the entry of SKU that the detail lines have some entries that SUSR2 =800 and some =300. If all the lines SUSR2 =300 it must not diplay nor =800. It must have both. My script Displays all records. Select * from SKU, Orderdetail (SKU.SKU=Orderdetail.SKU and SKU.SUSR2=(‘800’,’300’)
Name: dotnet_ohio Date: July 16, 2008 at 19:41:55 Pacific
Reply:
Instead of combining the two numbers together, I would use an or statement. Be careful with this when you use multiple parameters. You may want to throw in a "having" statement or an "in" statement for the SKU number.
Summary: I want to automate a process that I perform on a weekly basis for my job. Currently, I have a bunch of SQL scripts that I run through JMP, a comprehensive, but expensive statistical suite. This work...
Summary: I m working in Mysql database. I have loaded sum text file (contains 6000 entries and there are 3 fields )in it via the desired query, after loading i want to show the unique record of every separate ...