Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Database > Need help with SQL query

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.

Need help with SQL query

Reply to Message Icon

Name: dpolking
Date: May 21, 2009 at 06:45:27 Pacific
OS: Windows XP
Subcategory: Non-specific SQL code
Comment:

I have the following query:

SELECT "AB_JOB"."AB_JOB_NUM",
"SHEET_SKID"."SHEET_SKID_NUM",
"SHEET_SKID"."SHEET_NET_WT",
"SHEET_SKID"."SHEET_TARE_WT",
"SHEET_SKID"."SKID_DATE",
"SHEET_SKID"."SKID_PIECES",
"PRODUCTION_SHEET_ITEM"."COIL_ABC_NUM",
"SHEET_SKID"."SKID_SHEET_STATUS",
"SHEET_PACKING_ITEM"."PACKING_LIST"
FROM "AB_JOB",
"CUSTOMER_ORDER",
"SHEET_SKID",
"PRODUCTION_SHEET_ITEM",
"SHEET_SKID_DETAIL",
"SHEET_PACKING_ITEM"
WHERE ( "AB_JOB"."ORDER_ABC_NUM" = "CUSTOMER_ORDER"."ORDER_ABC_NUM" ) and
( "SHEET_SKID"."AB_JOB_NUM" = "AB_JOB"."AB_JOB_NUM" ) and
( "SHEET_SKID_DETAIL"."PROD_ITEM_NUM"="PRODUCTION_SHEET_ITEM"."PROD_ITEM_NUM" ) and
( "SHEET_SKID"."SHEET_SKID_NUM" = "SHEET_SKID_DETAIL"."SHEET_SKID_NUM" ) AND
( "SHEET_SKID"."SHEET_SKID_NUM" ="SHEET_PACKING_ITEM"."SHEET_SKID_NUM")
( ( "CUSTOMER_ORDER"."ORIG_CUSTOMER_PO" = '68501454' ))

I need to modify this to report all items even if
"SHEET_SKID"."SHEET_SKID_NUM" is NULL

Can anyone help me out?



Sponsored Link
Ads by Google

Response Number 1
Name: nails
Date: May 22, 2009 at 06:42:21 Pacific
Reply:

Not being familiar with your SQL environment or your data, my guess is you need to do an outer join:

FROM "AB_JOB",
"CUSTOMER_ORDER",
"OUTER SHEET_SKID",
"PRODUCTION_SHEET_ITEM",
"SHEET_SKID_DETAIL",
"SHEET_PACKING_ITEM"

Then again, it might be LEFT OUTER:

"LEFT OUTER SKEET_SKID"

I've used Informix, SQL Server, and Teradata and I've never heard of surrounding the objects with double quotes.


0
Reply to Message Icon

Related Posts

See More


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: Need help with SQL query
Need help with SQL-query (access) www.computing.net/answers/dbase/need-help-with-sqlquery-access/209.html

Need help modifying SQL query www.computing.net/answers/dbase/need-help-modifying-sql-query/433.html

need help with creating a table www.computing.net/answers/dbase/need-help-with-creating-a-table-/456.html