check and update

[techker]

hey guys how would i be able to take a table and check in anoter table if it is there ..if not put like (o) if it is (1)..

 

this checks the DB for the product

 

SELECT TbItemInventory.Name, xcart_products.productcode, TbItemInventory.QuantityOnHand, xcart_products.avail,xcart_products.productid,TbItemInventory.ID,TbItemInventory.xcart
FROM TbItemInventory, xcart_products
WHERE (
TbItemInventory.Name = xcart_products.productcode
)

[fenway]

What's "it"?

[techker]

?

 

if it is in the catalogue DB set it to 1 if not set it to 0

[fenway]

Why can't you just check?

[techker]

cause it is not me that will check every day when the update is done to check the products that were inserted and the one's that are missing...

[fenway]

I mean why can't you script just check -- why maintain a flag that's always out of date?