Đang Thực Hiện

151546 SQL Query

I am not quite able to get my query to do what i need it to do. See attatched file for query

IT NEEDS TO CHECK THE MATRIX_ITEMS.MATRIX_GROUP_CODE against the MATRIX_ELEMENT_SELECTION table.

The query needs to find all records in the MATRIX_ITEMS table that do not have matching data in the MATRIX_ELEMENT_SELECTION table based on the query limits provided above.

Next is simply needs to simply use the data returned from MATRIX_ITEMS table to delete matching items in the items table

DELETE FROM ITEMS

WHERE ITEMNO = MATRIX_ITEMS.ITEM_CODE

This all needs to be done in a sql query. should be simple for a seasoned sql pro.

Kỹ năng: Bất kì công việc gì, MySQL

Xem thêm: n query, SQL Query, sql based, simple query, query table, data query, matching items, query query, check sql, need sql query, sql sql, sql query sql query, simple mysql query, delete table sql, query mysql, sql done, sql delete, mysql query file, simple table sql, mysql sql file, simple sql query, query simple sql, mysql delete records

Về Bên Thuê:
( 59 nhận xét ) Belleville, United States

Mã Dự Án: #1897727

Đã trao cho:

jeffgan007

Hi, This can be done in one SQL statement. Please see PMB for details. Regards, Jeff

$10 USD trong 0 ngày
(17 Đánh Giá)
3.5