search menu
search by menu
search by combination
advanced search
My Wish List
Display My Wish List
Edit My Wish List
existing client login
client #:
password:
Search for a Single Pearl
I am looking for a
ANY
Half-Drilled
Undrilled
Drilled-Through
ANY
SELECT distinct tblVARIETY.VARIETY_DESCRIPTION,tblVARIETY.VARIETY_ID FROM tblINVENTORY LEFT OUTER JOIN tblVARIETY ON tblINVENTORY.VARIETY_ID = tblVARIETY.VARIETY_ID LEFT OUTER JOIN tblITEM_SHAPE_JUNCTION AS SHA ON tblINVENTORY.ITEM_ID = SHA.ITEM_ID LEFT OUTER JOIN tblSHAPE_DESCRIPTION AS SHAPE ON SHA.SHAPE_ID = SHAPE.SHAPE_ID WHERE ( VARIETY_DESCRIPTION not like '%Clasp%' AND VARIETY_DESCRIPTION not like '%-Black%' AND VARIETY_DESCRIPTION not like '%-Blue%' AND VARIETY_DESCRIPTION not like '%-Grey%' AND VARIETY_DESCRIPTION not like '%-White%' AND VARIETY_DESCRIPTION not like '%-Japanese%' AND VARIETY_DESCRIPTION not like '%-Multicolour%' AND VARIETY_DESCRIPTION not like '%Pink%' AND VARIETY_DESCRIPTION not like '%Mother%' AND VARIETY_DESCRIPTION not like '%-Peach%' AND VARIETY_DESCRIPTION not like '%-Purple%' AND VARIETY_DESCRIPTION not like '%-Silver%' AND VARIETY_DESCRIPTION not like '%-Orange%' AND VARIETY_DESCRIPTION not like '%?%' )AND (tblVARIETY.VARIETY_DESCRIPTION LIKE '%pearl%' AND tblVARIETY.VARIETY_DESCRIPTION NOT LIKE '%strand%') OR(tblVARIETY.VARIETY_DESCRIPTION LIKE '%pearl%' AND SHAPE.SHAPE_LONG_DESCRIPTION NOT LIKE '%"%'AND ( VARIETY_DESCRIPTION not like '%Clasp%' AND VARIETY_DESCRIPTION not like '%-Black%' AND VARIETY_DESCRIPTION not like '%-Blue%' AND VARIETY_DESCRIPTION not like '%-Grey%' AND VARIETY_DESCRIPTION not like '%-White%' AND VARIETY_DESCRIPTION not like '%-Japanese%' AND VARIETY_DESCRIPTION not like '%-Multicolour%' AND VARIETY_DESCRIPTION not like '%Pink%' AND VARIETY_DESCRIPTION not like '%Mother%' AND VARIETY_DESCRIPTION not like '%-Peach%' AND VARIETY_DESCRIPTION not like '%-Purple%' AND VARIETY_DESCRIPTION not like '%-Silver%' AND VARIETY_DESCRIPTION not like '%-Orange%' AND VARIETY_DESCRIPTION not like '%?%' ) ) ORDER BY tblVARIETY.VARIETY_DESCRIPTION
Cultured Pearl
Freshwater Pearl
Freshwater Pearl-BIWA
Freshwater Pearl-Wing
Mabe Pearl
Mabe Pearl-Blister
Mabe Pearl-Imitation
Mabe Pearl-Shell
Oriental Pearl
Pearl
Pearl-Imitation
Pearl-South Sea
Pearl-Tahitian
Seed Pearl
pearl
for either
earnings or a pendant.
They should be about
ANY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
millimeter in size
and
ANY
Black
Blue
Green
Grey
Mauve
Multicolour
Orange
Peach
Pink
White
in colour.
Go back for a different search
|
|
|
|
|
|
© 2008 Gambhirs Imports International
