Thanks for all the feedback. It is greatly appreciated.

That is what I needed to know.

Thanks to everyone here for their help. It is appreciated.

That was it. When using the Data Conversion it creates a copy of the input columns with the new data type. We were still using the original links.

Is there an...

I appreciate all the feedback.

That answers my question. Two columns it is.

Thanks

The "AND" in the Where Clause was the culprit. Thanks for all your help.

I am trying to link two tables based on the Work Order ID in a report. However, one of the table stores the Work Order type, ID, Sub ID, Lot...

I feel stupid! Gotta love Monday's!

Thanks. I appreciate it very much.

Got it! Thanks

Perfect! Thanks.

Table Definitions:

Cust_Order_ID (PK, FK, varchar(15), not null)

Part_Id (FK, varchar(30),null)

Desired_Ship_Date (datetime, null)

Sample Code (Used to return the sample data)

SELECT CUST_ORDER_ID, PART_ID, DESIRED_SHIP_DATE

FROM CUST_ORDER_LINE

WHERE CUST_ORDER_ID IN ('S31173', 'F-EMB FORECAST') AND PART_ID =...

Here is the data I want to retrieve. I want to find all records where there is a forecasted order (F-EMB FORECAST) and a firmed Sales Order (S31173) with the...

UPDATE CUST_LINE_DEL SET USER_ORDER_QTY = '9'

FROM CUST_LINE_DEL

JOIN CUST_ORDER_LINE ON CUST_LINE_DEL.CUST_ORDER_ID = CUST_ORDER_LINE.CUST_ORDER_ID

WHERE CUSTOMER_ORDER.ID LIKE 'F%' AND CUST_ORDER_LINE.DESIRED_SHIP_DATE < DATEADD(dd,60,getdate())

Got it. Thanks

What do I need to place at the beginning and end of my code to get it to look correctly on the posts? /code obviously did not work.

I got it. I did not need to join one of the tables. Thanks for all the help.

/code

UPDATE CUST_LINE_DEL SET USER_ORDER_QTY = '9'

FROM CUST_LINE_DEL

JOIN CUST_ORDER_LINE ON CUST_LINE_DEL.CUST_ORDER_ID = CUST_ORDER_LINE.CUST_ORDER_ID

WHERE...