Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
This was posted before, want to see what products are orphaned. Someone posted a solution once, now I cant find it via search :( Thanks! PromoManagers
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Run a SQL query like this...(note that I didn't test this) Code:
SELECT *
FROM bvc_Product
WHERE bvin NOT IN (SELECT ProductId FROM bvc_ProductXCategory)
|
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
That worked like a charm. PromoManagers Promotional Products
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.